select max(sal) from emp

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

Question Posted / sanjeev

Answer Posted / sanjeev

Is This Answer Correct ?

5 Yes

14 No

Please Help Members By Posting Answers For Below Questions

Can we change the table name in sql?

941

What is pls_integer in pl sql?

1105

What is a record in a database?

1062

Advantages and disadvantages of stored procedure?

1122

What is the difference between a database and a relational database?

1103

How long it takes to learn pl sql?

1010

When is the explicit cursor used ?

1034

What is the use of index in sql?

1017

Which is faster count (*) or count 1?

1035

How does left join work in sql?

1001

Which language is used in sql?

1058

Why we use cross join?

952

What are the rules to be applied to nulls whilst doing comparisons?

1323

What is auto increment in sql?

1121

is mysql query is case sensitive? : Sql dba

1101