select top(1) * from emp order by salary desc

From an Employee table, how will you display the record
which has a maximum salary?

Question Posted / sayed

Answer Posted / sayed

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Does pdo prevent sql injection?

931

What is the limitation on the block size of pl/sql?

987

What is sql deadlock?

1135

does sql support programming? : Sql dba

1039

What is percent sign in sql?

1283

What is restrict in sql?

1115

what tools available for managing mysql server? : Sql dba

1079

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

983

Explain how can you save or place your msg in a table?

1026

What is example of database?

1056

Difference between truncate, delete and drop commands?

1082

What is a sql statement?

955

What is procedure explain with program?

1017

how mysql optimizes distinct? : Sql dba

1079

what is view? : Sql dba

955