Translate to Tamil

Best Offers

Bigbasket [CPS] IN

Amazon Best Offers

Amazon Offers

Offers

Online Income

Best Online Offers

Wikipedia

Search results

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


No comments:
Write comments

Infolinks

Services

© 2014