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

What is the difference between view and stored procedure?

490

How do you optimize a query?

535

List and explain the different types of join clauses supported in ansi-standard sql?

810

how to calculate the difference between two dates? : Sql dba

546

What are different types of tables in sql?

526

What is trigger types in sql?

529

What is difference between table and view?

518

What is a sql statement?

529

what is a composite key ? : Sql dba

596

Why trigger is used in sql?

525

how to calculate expressions with sql statements? : Sql dba

524

What is the usage of the distinct keyword?

682

What are the ways on commenting in a pl/sql code?

511

Why commit is not used in triggers?

574

Can we use pl sql in sql server?

538