sql satement for 2nd maximum value

Answer Posted / sunil nandedkar

Select min(Salary)ThirdHighest from employees where salary
in (Select top 3 salary from employees order by salary desc)
For nth replace top 3 with top n

Is This Answer Correct ?    3 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

i am attending to US consulate i kept my projects on vb.net ,please help me what questions will be ask on vb.net in us consulate

1987


What is vb.net used for?

627


Name some of the features of C# which are not present in VB.NET?

644


What do you mean by serialization and deserialization?

622


What do you understand by vb.net?

688






Explain about Visual basic.NET culture?

670


What are the assembly entry points?

654


Is vb net a scripting language?

635


Described strong typing

658


What is visual basic.net culture?

586


Explain an assembly?

646


Name and explain some of the exclusive features which are present in vb?

625


What is misl code?

649


Explain an assembly and its use?

603


How to execute VB.NET PROJECTS,VB6.0 PROJECTS AND write their test cases.Need Reply Urgently

2100