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 mutating table error.

840

Can we use pl sql in mysql?

711

Is pl sql and postgresql same?

769

Is it possible to update views?

713

How to avoid duplicate records in a query?

749

How delete all data from table in sql?

754

What are the types of index in sql?

774

Define join and name different types of joins?

714

What is a natural join?

733

Define commit, rollback and savepoint?

765

How are sql commands classified?

803

Define sql delete statement.

744

How to execute a stored procedure?

757

What is nvarchar in sql?

715

What are the possible values that can be stored in a boolean data field?

719