select * from employee where salary = max sal

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

Question Posted / sudeep mishra

Answer Posted / sudeep mishra

select *
from employee
where salary = max sal

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Which is faster view or stored procedure?

946

what is sql server agent? : Sql dba

1110

What is output spooling in sql*plus?

1039

Can cursors be part of a trigger body?

1641

Explain the uses of database trigger.

1117

How many joins in sql?

1016

Can we join same table in sql?

1026

How many functions are there in sql?

1032

which types of join is used in sql widely? : Sql dba

983

What is not null in sql?

1061

what are integrity rules?

1035

What is the purpose of primary key?

1029

What is posting?

1041

What are the different operators available in sql?

1004

Can we insert data into view?

907