Friday, June 1, 2012

SQL ORDER BY Keyword

The ORDER BY keyword is used to sort the result-set by a specified column and to sort the records in ascending order by default


SQL ORDER BY Syntax
SELECT column_name(s) FROM table_name
ORDER BY column_name ASC or DESC


ORDER BY Example
SELECT * FROM Employee
ORDER BY FirstName

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.