From an Employee table, how will you display the record
which has a maximum salary?
Answer Posted / sayed
select top(1) * from emp order by salary desc
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is the difference between drop and truncate commands?
How does index help in query performance?
What sql does db2 use?
Explain what is a column in a table?
Why are cursors used?
how to load data files into tables with 'mysqlimport'? : Sql dba
What are the 3 types of behavioral triggers?
What is primary key and foreign key?
what are the advantages and disadvantages of views in a database? : Sql dba
What is a data manipulation language?
What is the difference between microsoft access and sql?
What is the use of desc in sql?
What is execute immediate?
Why cross join is used?
how is exception handling handled in mysql? : Sql dba