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
I have 6 months experience as project tarine and one and a half year experience as software engineer.Should i write taht my total experience id 2 years.
How many types of api testing are there?
what risks do u faced u r projest how do you solve
Anyone attended the manual testing interview with L&T infotech in recent past. please let me know the type of questions they can ask especially in PM round. Thanks
Explain thread testing.
Hi ALl, Can you please list out Q & A for Test Lead,which Interviewer may ask in interview for Test Lead position
explain fish model in detail?
What is system level testing?
i have 2.5 years of experience in manual testing and qtp. can anyone say me what kind of questions do they ask on manual testing and qtp.
What is mutation testing & when can it be done?
What is the difference between Sleep and wait in winrunner what is integration testing and types of testing present what is system testing what is data driven testing what is functionality testing if requirements are given to you then how do you write the test cases for it Account number = Ok cancel For above given form the valid account number starts from 1 to 1000 so is it necessary to input the 1,2,3 ….998,999,1000 test cases to check the conditions of valid account numbers I,e is it compulsory to write 1000 test cases for the above form
can u plz give an example for regression testing with example.
what could be the (realtime)bugs you come across in job portal and health care projects in terms of 1. high severity n low priority 2. high severity n high priority 3. low severity n low priority 4. low severity n low priority? pls its very urgent thanks n in advance n lukin forward for reply
How we test the bulk of contents in web page using manual testing? Is any open source tool available for that ? Thanks in advance..
KINDLY FORWARD ME THE INTERVIEW QUESTIONS & ANSWERS FROM REAL TIME POINT OF VIEW FOR 1.5 YEARS EXPERIENCED CANDIDATE. MY EMAIL ID IS sky_bird433@yahoo.com