i need department wise top 2 employees salary.which logic
i will use

Answer Posted / arun

Select top(2)* from table order by salary desc

Is This Answer Correct ?    2 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you have more than one trigger on a table?

709


Is sqlite good enough for production?

734


Are pl sql variables case sensitive?

770


What is a sql profiler?

770


Does asenumerable execute the query?

775






What is the process of copying data from table a to table b?

805


What is optimistic concurrency control? : Transact sql

746


How do I start sql profiler?

746


How much does sql certification cost?

746


What is forward declaration in pl sql?

758


What is rowid in sql?

676


What are the two types of cursors in pl sql?

735


What are triggers in sql?

749


Can you skip header records while loading? : aql loader

732


How do I run a program in pl sql?

701