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

What is a primary key? Explain

1028

What is the difference between null value, zero, and blank space?

1257

Why do we use procedures?

1007

What is the use of primary key?

1049

What are the differences between in and exists clause?

1169

What is procedure and function in sql?

1046

How many types of privileges are available in sql?

1404

Does view store data in sql?

1042

What is an example of translating a date into julian format?

1205

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

1120

What makes a good primary key?

1096

What does (*) mean in sql?

1002

What are local and global Indexes and where they are useful.

1494

What is the difference between syntax error and runtime error?

1185

How do I view an execution plan in sql?

1036