select * from employee where salary =( select max(salary) from employee);

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

Question Posted / dinesh kumar

Answer Posted / dinesh kumar

select * from employee where salary =( select max(salary) from
employee);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do you get column names only for a table (sql server)?

1100

How do you clear the screen in sql?

1010

How can I make sql query run faster?

960

Is sql a oracle?

914

What is the difference between mdf and ndf files?

1061

What does where 1 1 mean in sql?

978

What is bind variable in pl sql?

976

What is embedded sql what are its advantages?

958

Is nosql faster than sql?

970

What are dml commands?

939

What is normalization in sql?

962

What is cursor explain with example?

921

What is pragma in sql?

1020

What is the difference between between and in condition operators?

939

how do you know if your mysql server is alive? : Sql dba

1024