Thursday, October 16, 2008

Generic Syntax for SELECT Statement in SQL

"Select top n* (or) column names from
where
groupby
having
orderby asc/desc"

Top n --
Top statement used to get the top most rows of result.
asc -- for getting in ascending order and is defaultly available for every query
desc --for getting descending order

No comments: