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

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

Question Posted / manoj k

Answer Posted / manoj k

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

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between in and between in sql?

1034

Can you join a table to itself?

1108

Cite the differences between execution of triggers and stored procedures?

1072

What is function and procedure?

1017

What is the use of <> sql?

960

What are the types pl/sql code blocks?

1109

Is sql microsoft?

1032

Explain isolation levels. : Transact sql

1048

What are the types of index in sql?

1050

What is the difference between joins?

1023

Explain commit, rollback and savepoint.

982

What does (+) mean in sql joins?

1046

what are all the different types of indexes? : Sql dba

1035

Why we use cross join?

938

Can we update views in sql?

925