The top operator used to select top row from a table ------------------------------------------------------------------------- select top 1 * from tablename select top(2) * from TransPalanharPayment select top(10) PERCENT * from tablename

http://www.tutorialspoint.com/sql/sql-top-clause.htm

The top operator used to select top row from a table. For ex: select top(2) * from table_name

The top operator used to select top row from a table. For ex: select top(2) * from table_name

top query is used to select top rows from a table like select top(2) * from table_name

The TOP operator is used to select the top records. Means If You want to select first 2 records, then You use the following query select top 2 * from employee employee is the table name.

The TOP operator is used to specify the number of rows to be returned by a query.  The TOP operator has new addition in SQL SERVER 2008 that it accepts variables as well as literal values and  can be used with NSERT, UPDATE, and DELETES statements.

Top operator is used to specify the number of rows to be returned by a query.It can also be used with INSERT,UPDATE and DELETE statements .