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


Please Help Members By Posting Answers For Below Questions

Can we connect to postgresql using sql developer?

699


What is the starting oracle error number?

762


How do you optimize a stored procedure query?

739


What is a temporal data type?

773


Why do we use view in sql?

727






Is t sql a programming language?

761


What do you understand by pl/sql cursors?

741


Why are indexes and views important to an organization?

681


How can I see all tables in sql?

728


What is normalization sql?

724


can a stored procedure call itself or recursive stored procedure? : Sql dba

753


How to check if a column is nullable before setting to nullable?

776


What is the difference between local variables and global variables?

800


Explain two easy sql optimizations.

770


How do I add a primary key to a table?

748