Translate to Tamil

Earn Money


Best Offers

Amazon Best Offers

Offers

Best Online Offers

Amazon Offers

Earn Money Short URL

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

Contact Form

Name

Email *

Message *

Infolinks

© 2014