select sal,ename from emp where sal=(select max(sal) from emp);

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.

Question Posted / pramod janjirala

Answer Posted / pramod janjirala

select sal,ename from emp where sal=(select max(sal) from
emp);

Is This Answer Correct ?

32 Yes

7 No

Please Help Members By Posting Answers For Below Questions

How to combine two stored procedures in sql?

1119

Is record in pl sql?

915

Mention what does plv msg allows you to do?

1053

What are the different set operators available in sql?

972

what is sub-query? : Transact sql

1038

What are the different dml commands in sql?

1084

How to select 10 records from a table?

1096

What is the difference between syntax error and runtime error?

1064

How do I make my sql query run faster?

890

Sql technical questions

1200

Is nosql relational?

892

Is and as keyword in pl sql?

904

Why do we use joins in sql?

907

Why stored procedures are faster than query?

968

How to write a query to show the details of a student from students table whose

937