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 the questions that can be posed in an interview for a 5 year experienced person in manual testing
What is Independent Testing?
in the account there is 10,000 rupees and i entered 20000, in this case how will you test the application
What is the difference between pilot and beta testing?
explain fish model in detail?
What are the phases involved in software testing life cycle?
Explain accessibility testing and its importance in the present scenario.
If client give you a project then which testing you will perform first
What do we need to build a quality QC team ? a QC manager with all junior QCs or a QC manager with all senior QCs?
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 is back to back testing?
What is 'Account Conditioning'?
What is your Approach when you find 10 Sev-1 bugs in 50 test cases?
What types of documentation are used in qa?
what are the Cs in testing