SQL TOP - Introduction and syntax
SQL - Dec 03, 2008 at 18:00 PM by Rajmeet Ghai
Explain the SQL TOP statement. Write SQL syntax for the SQL TOP statement along
with an example.
TOP clause is used to specify the number of records to return.
Usually used for large tables.
Syntax:
SELECT TOP number|percent column_name(s) FROM table_name
Example:
SELECT TOP 2 * from employee
Also read
RAID is a mechanism of storing the same data in different
locations. Since the same data is stored, it is termed as
redundant............
Answer - A table can have only one ROWGUIDCOL
column......
Answer - It is created when CHECKPOINT statement
is executed.......
Answer - SQL Server Provides three types of
Transact-SQL statements namely DDL, DCL, and DML....
Answer - SQL Server database stores information
in a two dimensional objects of rows and columns called
table......
Answer - Index can be thought as index of the
book that is used for fast retrieval of information. Index uses one
or more column index keys and pointers to the record to locate
record.........
|
