Menu

Monday, 6 January 2014

TOP Clause


Emp_id
Emp_name
1
Suryagroops
2
Suresh
3
Mayank dixit
4
Suryagroops
5
Ramesh
6
Ramesh
7
Shalini
8
Sushil


                                                                 tbl_emp
TOP Clause

SELECT TOP (3) Emp_Name FROM tbl_emp

Result-
Emp_id
Emp_name
1
Suryagroops
2
Suresh
3
Mayank dixit

No comments: