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

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

Question Posted / suresh naik

Answer Posted / suresh naik

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

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do you rename a table in sql?

1111

What are the operators in sql?

1028

What are the different types of tables in sql?

1009

What is the need of a partition key?

987

How do I count rows in sql?

1004

what is table? : Sql dba

1062

What is procedure explain with example?

961

How do you get column names only for a table (sql server)?

1164

Can I create table without primary key?

997

How can you select unique records from a table?

1077

Can we insert data into materialized view?

942

What is autocommit sql?

993

Name the different types of indexes in sql and define them.

1151

How many commands are there in sql?

1028

What are different types of statements supported by sql?

1165