Select * from Employee where salary in(select max(salary) from Employee);

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

Question Posted / debjani chakraborty

Answer Posted / debjani chakraborty

Select * from Employee where salary in(select max(salary)
from Employee);

Is This Answer Correct ?

58 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is sqlite format?

1113

What is cartesian join in sql?

1030

what is auto increment? : Sql dba

965

what is 'trigger' in sql? : Sql dba

1015

What are the different types of tables in sql?

931

What is normalisation in sql?

1005

Can we perform dml on view?

976

what is online transaction processing (oltp)? : Sql dba

938

Are null values same as that of zero or a blank space?

969

How do you explain an index number?

1024

what are ddl statements in mysql? : Sql dba

1114

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

1976

Is oracel sql developer written in java?

1060

What are schema-level triggers?

1047

How to run pl sql program in mysql?

942