how 2 find out nth salary.plz write sql qurires

Answer Posted / suresh yadav

select * from emp where &n=(select count(distinct(sal))from
emp b where emp.sal<=b.sal);

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can Anbody please send me Daily Work status format in which I can save my daily work activity

2106


what types of bugs will we find out in banking projects

1833


What are the different levels of manual testing?

661


What are the possible test scenarios around AVS check of any credit card? (Testing through payment gateway online) (What are the fields we should check while checking AVS and CVV)

1113


What is Traditional testing & Object Oriented testing?

1961






Explain the manual testing process?

717


hai friends i did my bcom (distance with out inter)and iam pursuing mca(distance alagappa university)iam learning testing cource in ameerpet can i elgibel for testing jobs pls guide me … …and send details to rangavijetha@gmail.com..thanks

1349


What are differences in testing a client server and a web application?

1508


Hi Everybody could you please send me the ISTQB Material to my mail id karthik18487@gmail.com Thanking you in advance

1611


Hi friends Does anyone have screen shot of POWERMHS and please can anyone post anything which will be helpful to understand POWERMHS. thanks.

2521


Can you explain tailoring?

696


what risks do u faced u r projest how do you solve

1631


How the application is launched to the production environment?

1192


tell wat u did in ur banking project?

1848


What are some best practices that you should follow when writing test cases?

673