Loading
Define Top Operator in sql
8 Answers
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
Sanjeev KumarPosted Jul 19, 2016, 2:09 AM
http://www.tutorialspoint.com/sql/sql-top-clause.htm
Munesh SharmaPosted Jun 20, 2015, 6:23 AM
The top operator used to select top row from a table.
For ex:
select top(2) * from table_name
Rahul PrajapatPosted May 30, 2015, 9:58 AM
The top operator used to select top row from a table.
For ex:
select top(2) * from table_name
Rahul PrajapatPosted May 30, 2015, 9:58 AM
top query is used to select top rows from a table
like
select top(2) * from table_name
Pankaj Kumar ChoudharyPosted Mar 29, 2015, 9:00 AM
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.
Netaji ChavanPosted Oct 18, 2013, 6:42 AM
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.
Mandar DesaiPosted Jul 5, 2012, 5:37 AM
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 .
divyaPosted Jun 19, 2012, 8:31 AM