Friday, 10 December 2010

SQL Top









The TOP clause is used to specify the number of records to return.

Syntax
SELECT TOP number column_name(s)
FROM table_name


custcode
custname
city
qty
rate
1
Siva
Srivilliputtur
50
70
2
Bala
Sivakasi
30
56
3
Kanna
Madurai
100
200
4
Vijay
Chennai
30
30
5
Kodee
Sandnes
60
80
5
Kodee
Srivilliputtur
60
30

Example :1
Select Top 2 custcode, custname from custmast

custcode
custname
1
Siva
2
Bala

Example :2
Select Top 3 * from custmast 

custcode
custname
city
qty
rate
1
Siva
Srivilliputtur
50
70
2
Bala
Sivakasi
30
56
3
Kanna
Madurai
100
200

 Share This Post


Friendly Learn Translate to Tamil

Smilely

Services

© 2014