Click here to Skip to main content
16,021,041 members
Search within:


order by clause sub queries
Please Sign up or sign in to vote.
0.00/5 (No votes)
why the "order by" clause in sub queries must be associated with "top" clause in sql server..??
Posted
Add a Solution
Comments
Karthik Harve 18-Aug-11 6:07am    
thank you...

1 solution

It doesn't:
SQL
SELECT [Id]
      ,[Customer]
      ,[date]
      ,[Value]
  FROM [myDatabase].[dbo].[Customers]
  ORDER BY [date]
Works just fine...
 
Share this answer
 
Posted
Add a Solution

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

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
ORDER CLAUSE IN QUERY
Can you use multiple order by clauses in with at least one list join in linq query?
Order by clause disturbs the grouping in the query.
order by clause not working
Top Clause, order by clause
ORDER BY CLAUSE IN sql query where to put
Order by Clause
TSQL query : passing parameter to sp for in clause
order by clause is not working in temp table?
How to run SQL query with a update statement, where clause and order by/

Advertise
Privacy
Cookies
Terms of Use
Last Updated 18 Aug 2011
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web04 2.8:2024-07-22:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900