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 |
|
chinlax
Starting Member
30 Posts |
 Posted - 2011-10-17 : 00:33:45
|
| Hi all,I am struggling to get this1)Write a query to get 2nd & 6th max salary from EMP table2)Write a query to get least 3 salaries from the EMP tablei can get separately the 2n and 6th max but how to club bothand how to the least 3 salaries, i want to display all the 3 least salaries.Emp table contains columns. empno, ename, sal, deptno can any one help me outThanks in advance. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Qery to select 2nd n 6th max salary