how 2 find out nth salary.plz write sql qurires

Answer Posted / guest

select top 1 salary from(select Distinct top 2 salary from
employee order by salary desc)order by salary

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an mr?

665


How quickly we need to fix the bug? Or how soon the bug should get fixed?

702


What are the various techniques in black box testing?

721


What are the different cost elements involved in implementing a process in an organization?

677


What are the different servers and difference between them?

1603






hi this is ashok , i never worked in medical domain , can any one pls send me with proper exaple pls Question is while emergency or normal patitent enter into hospital he entered his first and last name and he enter emergency coloumn , write test case on these ,

1603


Hi, I am planing to give ISTQB - Foundation level exam. Can anyone forward the ISTQB materials at laxmi_002@rediffmail.com mail ID.

1457


I have 2 yr Localisation testing exp now i want to job in MNC My manualtesting knowledge+2 yr exp sufficiant for in MNC

1574


Have you worked in UDAP (Credit Card act 2009) project?What did you test in Billing & Payment modules?

1767


What are the two main categories of software testing?

680


how agile testing is performed and what are the related documents.

1391


Can you explain boundary value analysis?

654


In cycle 1 we have 100 test cases out of which 95 test cases are PASS and 5 test cases are FAIL. So in cycle 2 how many test cases performed as a part of regression testing?

1113


Hi Friends, I have completed 3 rounds of an Interview with HR discussion also and got Offer letter from Cognizant, but after in 30 min they send one more email like Offer is on Hold, and its not valid... Could you please guide me any one , Can i expect Offer again from Cognizant or Can i drop the hopes ?.

1366


What is positive and negative testing?

662