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 is the responsibility of programmer’s vs QA?
what is the diff. bw separate database testers and manual testers with sql knowledge guys... iam confusing so much ,,in cmpny database testers are not working on manual..? both positions are same are not? explian clesly with example? thank u
what type of testing techniques are using after accept the build?
Can you explain exploratory testing?
what kind of testing have u done?
Anyone tell me the test cases of Shopping Favorite
Hi I want to start online training couses for testing Any body plz help me out how to start the online courses Plz post the answer here or send me a mail for kommineni.1020@gmail.com
Can test condition,testcase and testscript help u in performing the static testing
Write the 10 high test cases for making video call/face time?? Write the test cases for credit card accessing the money transfer?? Write the test cases for file transfer from one user to other from Google Drive/drop box?
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?
Hi, i am looking job in perfomance testing using Loadrunner can any body help me a project in any domine plz(Usah) chs_29@rediffmail.com
after completeing testing ,what would u deliver to the client?
What is regression testing? When to apply it?
You may undergone many projects. Do all the projects match up with customer’s expectations?
what are the templates for daily,weekly and monthly reports? plz reply ASAP.