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 run pl/sql statements in sql*plus?

756

The in operator may be used if you know the exact value you want to return for at least one of the columns.

723

Can sql function call stored procedure?

734

What is a data definition language?

790

What is case function?

776

what is the command used to fetch first 5 characters of the string? : Sql dba

1365

How do I know if I have sql express or standard?

755

What is cold data?

676

Could you please provide oca (oracle 10g) dumps for my certification ?

4780

Determine if oracle date is on a weekend?

763

Which sql statement is used to delete data from a database?

650

how to drop an existing index in mysql? : Sql dba

714

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

810

What is multiple partition?

692

Is left join faster than inner join?

832