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
What is record in pl sql?
How do I make my sql query run faster?
What are the benefits of pl sql?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
what is a trigger in mysql? : Sql dba
what is bcp? When does it used? : Sql dba
how to convert character strings to dates? : Sql dba
What is a scalar value in sql?
What are the main features of cursor?
How do I sort a table in sql?
How can I get the number of records affected by a stored procedure?
how many sql dml commands are supported by 'mysql'? : Sql dba
What is execute immediate?
What is bind reference and how can it be created?
Is it possible to pass parameters to triggers?