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

Explain the methods used to protect source code of pl/sql.

965

When can we use the where clause and the having clause?

968

How do I edit a trigger in sql developer?

938

What are triggers and its types?

996

Explain the components of sql?

995

Can we use ddl statements in stored procedure sql server?

966

How would you reference column values before and after you have inserted and deleted triggers?

1021

Can a varchar be a primary key?

955

What is restrict in sql?

1035

What is the use of desc in sql?

916

Can we call procedure in select statement?

976

What are the different set operators available in sql?

974

How to add, remove, modify users using sql?

980

Can we group by two columns in sql?

946

How can get second highest salary in sql?

911