SELECT Top(10) *
FROM [Order Details]
ORDER BY [Unit Price] * Quantity DESC
And you will get the 10 most valuable orders listed.
It's nice to see this omission finally added to the SQL Compact syntax.
Sunday, August 26, 2007
TOP clause now supported
So now in SQL Compact 3.5 you can make queries against Northwind.sdf with the following syntax:
SELECT Top(10) *
FROM [Order Details]
ORDER BY [Unit Price] * Quantity DESC
And you will get the 10 most valuable orders listed.
It's nice to see this omission finally added to the SQL Compact syntax.
SELECT Top(10) *
FROM [Order Details]
ORDER BY [Unit Price] * Quantity DESC
And you will get the 10 most valuable orders listed.
It's nice to see this omission finally added to the SQL Compact syntax.
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment