Top « Select Query « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. Select Query
  3. Top
1.TOP Clause in DELETE Statements
2.Get the top two rows by using a TOP keyword and specifying the ORDER BY clause with a column name
3.Get the bottom two rows by using a TOP keyword and specifying the ORDER BY clause
4.Add the TOP statement: see the first five rows in the result set
5.Top with descending order
6.TOP 2 WITH TIES
7.Define variable to query top number of records