select * from emp where sal=(select max(sal) from emp); OR

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

Question Posted / os reddy

Answer Posted / os reddy

select * from emp
where sal=(select max(sal) from emp);

OR

select * from emp
where sal in(select max(sal) from emp);

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what are sequences

1685

Write a sql query to find the names of employees that begin with ‘a’?

972

What is bind reference and how can it be created?

989

What is rowid in sql?

934

What is blind sql injection?

1020

Does sql require a server?

966

Why do we use cursors?

942

What is union and union all keyword in sql and what are their differences?

1064

What is plpgsql language?

1007

What are all the common sql functions?

985

Is sql a backend?

985

What are transaction and its controls?

991

What are the advantages of stored procedure?

965

Is grant a ddl statement?

867

What is left join in sql?

1023