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

What and why is api testing?

949


Encapsulation of attributes and operations inside objects makes it easy to obtain object state information during testing. is it true.explain

1647


what is the function generator?

1702


Can you explain requirement traceability and its importance?

662


i looking for the software testing job with the exp of (1.5 yrs ), if anybody knows how to approach the companies ,pls let me know , possible que which will be asked in interview ? pls send me sample resume for testing ....pls do the favour as soon as posible .

1563






What is revision history and the content of revision history table?

1565


can any one send sample test cases for database testing by taking an example? also leave emailid please. thanks (very urgent)

2666


Presently working in software company as a software test engineer with 1.5 yrs of experience but i am 2002 passout.Gap is 6 yrs.Is there any problem getting job in MNC? Which criteria HR follows for recruiting test engineer?

1621


I have an UI issue "please fill out this field" pop up in firefox browser keeps scrolling with the page is it valid???

1442


Explain some techniques for developing software components with respect to testability.

3058


is it not possible to automate full project??what r the parts in project that cant be automated(tht has to be done manually)?

1997


How do u go about testing of web application?

1651


What type of projects can include in Logistics Domain? and what is the type of domain for project which include Driving license renewal, Different type of title registration etc...

2538


Hi, Please can one tell me how to test the usability testing, which method has to be used, how to write the report? Thanks Deepa

1588


what are the types of Bug?

1064