get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)


select ename,Salary from Emp a group by Ename,Salary
   having 4=(select COUNT(distinct( salary) )from Emp b where a.salary<=b.Salary)

Comments

Post a Comment

Popular posts from this blog

i am writing With sad hearts some problems with my windows phone samsung omnia w

Last month i bought a Windows phone Samsung Omnia W.... After a few days i realise the some problem with it...... WP7.5 (Mango) is already in its second generation but it still has many restrictions, limitations and serious usability issues. This is a list of its shortcomings as compared with other smartphone OS in the market. We are not comparing special features or abilities but those which have become the norm for all smartphones and even dumb phones. An Android, Symbian or MeeGo phone would have almost none of these shortcomings. An iphone share some restrictions with WP7.5 but is still miles ahead. Even the Nokia N9 running the first generation MeeGo OS is far better with none of the disastrous issues which impact on the sheer usability of the phone. OS LIMITATIONS 1. No true multitasking - apps are frozen in the background. 2. No Divx/Xvid video codec support. Zune will convert with loss of quality. 3. No mass storage mode. 4. No micro-SD card support. 5. Only suppor...
Read more

Delete Duplicate Records in DataBase sql server

if your Tabel has a duplicate data and you want to delete only duplicate records and want to save only single records in your table then this single line of code will help you.......... select * from tblname where tblname. %%physloc%% not in(select MAX(b.%%physloc%%)  from tblname   group by b.coloumnname) Hope it helped you........ plz comments.........
Read more