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

Is pl sql a programming language?

925

What is loop in pl sql?

981

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

945

What is scalar function?

999

Is sql a microsoft product?

896

Inline the values in PL/SQL, what does it mean.?

1157

How do you define a foreign key?

938

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1084

List the ways to get the count of records in a table?

852

How to display Row Number with Records in Oracle SQL Plus?

991

How do I count rows in sql?

947

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1058

List out the acid properties and explain?

904

What is the difference between microsoft access and sql?

959

What is trigger with example?

1012