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

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

Question Posted / nagendra

Answer Posted / nagendra

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain ddl statements in pl/sql?

576

Is sqlite good enough for production?

531

what are the types of subquery? : Sql dba

584

what is the difference between a local and a global temporary table? : Sql dba

549

Can you selectively load only those records that you need? : aql loader

607

What are the syntax and use of the coalesce function?

551

What are dml commands?

524

What do you mean by “trigger” in sql?

615

how to get a list of columns in an existing table? : Sql dba

540

Which language is used in sql?

514

What is auto increment feature in sql?

616

Explain architecture of sql server notification services?

620

What is pls integer?

579

How do you write an inner join query?

511

How do I debug a stored procedure?

625