Write a query to find five highest salaries from EMP table.
(there is a column SALARY)

Answer Posted / alex, n.y [microsoft]

SELECT TOP 5 [SALARY] FROM [EMP]

Is This Answer Correct ?    3 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is %type in pl sql?

712


What are some predefined exceptions in pl/sql?

744


How to avoid duplicate records in a query?

749


What are the possible values for the boolean data field?

693


What does 0 mean in sql?

694






Why do we use sql constraints?

858


What is union and union all keyword in sql?

724


What is a join query?

722


The in operator may be used if you know the exact value you want to return for at least one of the columns.

728


What is character functions?

745


What is the order of sql select?

763


State some properties of relational databases?

762


Can you join a table to itself?

712


what are the different type of sql's statements ? : Sql dba

701


What does inner join mean?

758