Define Top Operator in sql

Post

By Sahista Qureshi in SQL on Jun 06 2012

Jul, 2016 19
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
- 0
Jun, 2015 20
http://www.tutorialspoint.com/sql/sql-top-clause.htm
- 0
May, 2015 30
The top operator used to select top row from a table. For ex: select top(2) * from table_name
- 0
May, 2015 30
The top operator used to select top row from a table. For ex: select top(2) * from table_name
- 0
Mar, 2015 29
top query is used to select top rows from a table like select top(2) * from table_name
- 0
Oct, 2013 18
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.
- 0
Jul, 2012 5
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.
- 0
Jun, 2012 19
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 .
- 0

Most Popular Job Functions