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
Can anyone tell me, What is wound fixing?
What are the different levels of manual testing?
What is back to back testing?
Why would we not include these?
can anyone tell anyone is providing training for CSTE exam in bangalore? and can u send some links related to this?
What is mean by Schedule report who is the responsible for generated that one ?
What are the standard you follow in your company to prepare test plan document? Content is same in every standard or not. Also is there any document to read about the testing standards? Thanks in advance for giving me the answer.
Can anyone tell me about banking project? abt the transactions? the flow?
Describe your personal software development process.
1)can u tell me, what is the roles and responsibles for database tester in DB testing from requirement stage to UAT stage....2) what are the i/p documents he wants and who wil give the i/p docs. to DB tester.and tell me what exactly db test case means what?
what are the responsibilities for QA tester to test application on UNIX environment??? what skills required for unix???
I HAVE AN INTERVIEW IN A SOFTWARE COMPANY FOR THE POST OF FUNCTIONAL TEST ENGINEER. THEY WANT THE PERSON FROM BCOM BACK GROUND( I AM A BCOME GRADUATE 2006) AND THE PERSON SHOULD HAVE GOOD ACCOUNTS KNOWLEDGE. NOW I WANT TO KNOW WHAT KINDS OF QUESTIONS THEY CAN ASK OR CAN GIVE IN WRITTEN TEST. I M NERVOUS COZ ITS BEEN 5 YEARS I HAVE DONE BCOM. SO HOW SHUD I PREPARE FOR INTERVIEW.PLEASE HELP? reply me pls. its urgent. thanks
What are the main key components in web applications and client and server applications? And explain the differences between them?
What is the difference between latent and masked defects?
What r the domain for pharma, interview if they ask about phrma application, what need to tell, is there anybody have screens or any information please tell me and if have URL let me know please.