Sahista Qureshi
Define Top Operator in sql
By Sahista Qureshi in SQL on Jun 06 2012
  • Sanjeev Kumar
    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
  • Munesh Sharma
    Jun, 2015 20

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

    • 0
  • Rahul Prajapat
    May, 2015 30

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

    • 0
  • Rahul Prajapat
    May, 2015 30

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

    • 0
  • Pankaj  Kumar Choudhary
    Mar, 2015 29

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

    • 0
  • Netaji Chavan
    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
  • Mandar Desai
    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
  • divya
    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


MOST LIKED QUESTIONS