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

difference between anonymous blocks and sub-programs.

1188

Can function return multiple values in sql?

1098

how would concatenate strings in mysql? : Sql dba

1138

What is the non-clustered index in sql?

1102

What is meant by truncate in sql?

1107

What has stored procedures in sql?

1098

What is set serveroutput on?

1177

what is innodb? : Sql dba

1163

What is an index in sql with example?

1018

What is sql engine in oracle?

1038

how to include comments in sql statements? : Sql dba

999

What is the main reason behind using an index?

1057

Can we insert in view in sql?

1100

Is foreign key mandatory?

1064

what are string data types? : Sql dba

1092