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

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

Question Posted / aruna parulekar

Answer Posted / aruna parulekar

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

Is This Answer Correct ?

14 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Does pdo prevent sql injection?

931

What are all the ddl commands?

1180

How to pipe multiline string to isql?

1005

How do I run a sql query in pgadmin 4?

959

When should I use nosql database?

1006

What does <> sql mean?

1084

Are sql database names case sensitive?

1000

What are the possible values for the boolean data field?

962

Is natural join same as inner join?

935

What are the two characteristics of a primary key?

973

Can you load data into multiple tables at once? : aql loader

1066

What do you mean by stored procedures? How do we use it?

993

How we can update the view?

1049

Can I call a procedure inside a function?

1011

What are packages in pl sql and also explain its advantages?

1038