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
What are quality assurance and quality control?
Tell me the algo for convering number into words. Meanse if the number is 4567 then it should print Four Thousand Five Hundred Sixty Seven
could anyone explain application testing in sequence order i don't have any experience in that
what is the main field of bugzilla which we fill to report bug to any developers???give some brief description??
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?
Why should you care about objects and object-oriented testing?
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.
What is the difference between functional requirement and non-functional requirement?
According to RBI rule how much money can be transferred through online banking at one time...?
How do you determine user soad for a perf test of a Web application?
what is localization and globalization.and what are the ways way are going to test the particular application?how can we identify factual, visual, corrupted characters, link errors, formatting errors, etc in locallization?iam going to attend the interview on localization concepts and languages like : German, Japanese, French, Russian, Italian, Chinese, Korean, Portuguese and Spanish .tell me the process how to do testing above concepts let me know its urgent:anilaluvala@gmail.com 9908814046
Why it is recommended to add verification checks to your all your scenarios?
What is common interface?
What is bug, deffect, issue, error?
How to test an Scheduled event? For ex: in an investment banking application, the scheduler will create an equity anbd user has nothing to do but tester has to test if the instrument is created properly or not?