Interested to Buy Any Domain ? << Click Here >> for more details...
how 2 find out nth salary.plz write sql qurires
- 8 Answers
- 12014 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
How should validation activities be handled?
How to find that tools work well with your existing system?
how we write test cases to brs,srs,hlds,llds
What are the RBI rules has to follow by a bank for online precesseing. ?
Which test cases are written first: white boxes or black boxes?
hai friends i need a general test cases for check box,drop down button and radio butoon can anybody reply me plz..........thanks in advance
Artifacts in design phase of SDLC ?
If you're given a program that will average student grades, what kinds of inputs would you use?
How to Generate Test Case for Shopping Cart?
What are the principles of software testing?
What is regression testing? When to apply it?
What is deferred status in defect life cycle?
What is quality center? How many built in tables does quality center have?
Can any one share the domain knwoldege of Telecom Jeeva jeevachr@gmail.com
plz tell me the difference b/w PB/MF based appl.with examples. Thanks
