Select * from Employee where sal = (select max(sal) frpm Employee)

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

Question Posted / pradeep sahoo

Answer Posted / pradeep sahoo

Select * from Employee where sal = (select max(sal) frpm
Employee)

Is This Answer Correct ?

25 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain some predefined exceptions.

1043

What is program debugging?

1259

Can you join a table to itself?

1138

What is difference between inner join and cross join?

974

What are pl/sql cursor exceptions?

1111

Differentiate between syntax and runtime errors.

1195

What is sql integrity?

1165

What is the difference between left and left outer join?

951

What does truncate mean in sql?

1032

What is difference between sql and excel?

1100

What is query syntax?

980

What is sqlite used for?

1008

How do you delete data from a table?

1048

What is the best free sql database?

1058

How do I run a script in sql developer?

955