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

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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.