how 2 find out nth salary.plz write sql qurires
- 8 Answers
- 9420 Views
- Syntel, I also Faced
- E-Mail Answers
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
Can any1 tell me suppose u r doing manual testing on unix platform with Shell Script, then how it is done? How u r implementing it & what is the use of Shell scripting on Manual Testing?
What is PBX Testing & What is Test coverage?
wht is Manual Testing Frame work
what is the difference between section & test feature in test case documention?
how to write defects in excel sheets when defects occured
1.What is bidirectional traceability ??? and how it is implemented? 2.What is Automation Test frame work ? 3. Define the components present in test strategy? 4. Define the components present in test plan? 5. Have u written Test plan ?…. thank u!plz reply........
what is meant by application server and its functions?
why QA team is necessary for an organization?
i) functional test cases can we consider for regression test ? or we have to write separet test cases for regression test ? ii) How to write the system test case and what are the technique shall we have to follow ?
how will the test plan is pepared in ur organisation>?
how to test a store procedure?
how to verify a button size (e.g Login Button) on a web page have same dimension prescribed by Client in UI Testing..??
What is Catapult Testing in E-Learning Domain?
Can anyone please answer the below question on Manual Testing: Tell me about atleast 5 bugs you come across in your last testing?
i have done B.E. computer in 2009 i have done software testing course and also 6 months exp in testing on live project as trainee, now a days i am searching job in pune. can any one tell me any opening in pune?
