select * from employees where salary=(select max(salary) from emplpoyees);

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

Question Posted / amit kumar agarwalla

Answer Posted / amit kumar agarwalla

select * from employees
where salary=(select max(salary) from emplpoyees);

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how to use regular expression in pattern match conditions? : Sql dba

1040

What is a pdo connection?

1050

What is difference between stored procedure and trigger?

1175

Can you join views in sql?

961

What is dialect in sql?

954

What are joins in sql?

1050

How can we make an if statement within a select statement?

1018

What does where 1 1 mean in sql?

1046

What is native sql query?

1028

What are sql*plus environment variables?

1099

Can we insert in sql function?

1094

what are the types of join and explain each? : Sql dba

1043

what is an index? : Sql dba

1003

what is a trigger in mysql? Define different types of trigger. : Sql dba

1074

Explain normalization and what are the advantages of it?

954