how 2 find out nth salary.plz write sql qurires

Answer Posted / ramthiraviyam

In MySQL ,

we can get the nth salary using LIMIT IN MySQL Query .
Example:
if you want to take 7 th largest salary From emp table,

SELECT salary FROM emp order by salary desc LIMIT 6,1

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When the GUI Testing will be held on the V model ?

1716


diff b/w desktop based testing & web application testing

1572


Can you do system testing at any stage of sdlc?

657


Hi Friends, Can anubody give me brief overview of Automation tools.. (basics of tools-summary)of following tools? 1.Qualty Center 2.Load Runner 3.Win Runner 4.Q.T.P mail me on ...rachna.huda@gmail.com

1708


Sentence "Working from onsite is effective" is growing in IT field. How do we bring that knowledge to offshore and do an effective job in Offshore?

1668






What does a manual tester need to become proficient with db testing?

689


why use caffine for HPLC calibration ?

1659


Am putting E-commerce project in my resume can any one please tell me about E-commerce application explaination..

2435


What type of testing you perform in organization while you do system testing, give clearly?

697


What is defect cascading in software testing?

723


What type of metrics would you use?

1732


wat is test management ?what are the components available in test management?

1597


Name three reasons why the tester may choose to record in Context Sensitive mode.

1855


is it possible web application make it as executable file

1887


What is regression testing? When to apply it?

670