how 2 find out nth salary.plz write sql qurires
Answer Posted / nagapawan
iam taking table name as emp. this is to find out nth salary
eg: select * from emp
where n-1 = (select count(*) from emp e
where emp.salary<e.salary)
in place of n-1 you can keep zero for first hight salary
and 1 for second hightest salary.....etc
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
how to create automation frame work ?
.In languages testing, what is the fixed part and changing part?
What are the interview question on insurance domain in manual testing
How to explain the Insurance project in the interview?
wht is Manual Testing Frame work
diff b/w desktop based testing & web application testing
what types of testing have u done in ur project?and expalin it detail?
Can any body tell me in real time how cookies testing is done. And please tell me the steps.And for cookies testing test cases is needed.
Password is having 6 digit alphanumeric then what are the possible input conditions?
Can anyone tell me about banking project? abt the transactions? the flow?
Login screen with Username, Password input fields,remember me check box,sign in and reset button write Test Cases for GUI, Funcitonal, Negative, Usability and Security testing.
What are the cases why parameterization is necessary when load testing the Web server and the database server?
Why do you need to parameterize fields in your virtual user script?
Hi, what do you mean by internal auditing? what are the things they do in internal auditing?what they review? THNX in Advance
Have you prepared traceability matrix and how to prepare it?