how 2 find out nth salary.plz write sql qurires

Answer Posted / yogini_bhosale

select MAX (salary from employee)
where
salary not in ( select TOP N+1 salary from employee)
ORDERBY salary desc();

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain Testing process in your organization?

1090


What is the difference between stlc and sdlc?

618


How can you do the usability testing?

720


tell me 5 new requirements in ur project? plz urgent

1964


What can you tell about the project if during testing you found 80 bugs in it

1822






What is the difference between pilot and beta testing?

710


what is entry and exit criteria and explain it?

1028


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?

1569


what are the advantages of manual and automation testing ? and which one would u term as efficent testing and effective testing ?pls do reply thankx in advance

1445


How many types of api testing are there?

652


What is the difference between load and stress testing?

720


What do you understand by usability testing?

660


How can data caching have a negative effect on load testing results?

2377


What are the tasks of test closure activities in software testing?

627


1. what exactly is heuristic checklist approach for unit testing ?

2226