Is there any way to write 'ORDER BY' clause before where condition in sql?

Question

0.00/5 (No votes)

See more:

Hello,

I am using this query according to my condition but it's getting error:-

SQL

select * from(SELECT UUSLaminateThumbnailImage,UUSLaminateImage,UUSLaminateName,percentAdded FROM UUSLaminates order by UUSLaminateName asc) WHERE UUSLaminateID=@imgId

The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified.

Please help me.

Thanks in Advance.

Ankit Agarwal
Software Engineer

Posted 12-Feb-14 1:50am

ankit.agg1984

Add a Solution

Comments

scottgp 12-Feb-14 7:58am

Why are you trying to include the "order by" in the subquery? Why even have the subquery here? It doesn't seem to be serving any purpose.

[no name] 12-Feb-14 8:00am

I need a ascending order of UUSLaminates.

[no name] 12-Feb-14 8:01am

according to UUSLaminateName

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Peter Leow · Answer 1 · 2014-02-12T02:06:00

Solution 1

This will do:

SELECT UUSLaminateThumbnailImage,UUSLaminateImage,UUSLaminateName,percentAdded FROM UUSLaminates WHERE UUSLaminateID=@imgId order by UUSLaminateName asc

Posted 12-Feb-14 2:06am

Peter Leow

Comments

[no name] 12-Feb-14 8:10am

No,
I want to first sorting and then Where condition apply.,

Pete O'Hanlon 12-Feb-14 8:31am

Why? Sorting post where condition will still put the data into the correct order.

Peter Leow 12-Feb-14 8:57am

The order of records in the table does not matter, what does matter is the ordered output from your sql query.

Is there any way to write 'ORDER BY' clause before where condition in sql?

1 solution

Solution 1

Add your solution here

Preview 0

Is there any way to write 'ORDER BY' clause before where condition in sql?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us