Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
leoiser
Starting Member
20 Posts |
 Posted - 2007-07-04 : 04:44:28
|
| I ve a table having below inforamtionEmpID EmpName Timein LoginDate***********************************emp1 Ebin 1012 07/04/2007emp1 Ebin 1130 07/04/2007emp1 Ebin 1421 07/04/2007emp1 Ebin 1800 07/04/2007emp1 Ebin 2145 07/04/2007QBM2 Raj 1212 07/04/2007QBM2 Raj 1330 07/04/2007QBM2 Raj 1521 07/04/2007QBM2 Raj 1804 07/04/2007QBM2 Raj 2025 07/04/2007SSM2 John 0212 07/04/2007SSM2 John 1030 07/04/2007SSM2 John 1221 07/04/2007SSM2 John 1904 07/04/2007SSM2 John 2234 07/04/2007RAH2 Ram 0812 07/04/2007I want to get top 3 of all employees TimeINResult should be EmpID EmpName Timein LoginDate***********************************emp1 Ebin 1012 07/04/2007emp1 Ebin 1130 07/04/2007emp1 Ebin 1421 07/04/2007QBM2 Raj 1212 07/04/2007QBM2 Raj 1330 07/04/2007QBM2 Raj 1521 07/04/2007SSM2 John 0212 07/04/2007SSM2 John 1030 07/04/2007SSM2 John 1221 07/04/2007RAH2 Ram 0812 07/04/2007How I will achieve this without using cursor?please help.Thanks in advance |
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
How to get top 3 of distinct Employees