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

Define sql delete statement.

560

what are aggregate and scalar functions? : Sql dba

550

What is pivot query?

591

Mention what does plv msg allows you to do?

662

How do I count rows in sql query?

490

How to select all records from the table?

605

What are the two virtual tables available at the time of database trigger execution?

631

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

1132

What is a subquery in sql?

505

What is a design view?

518

What is the maximum database size for sql express?

532

what does the t-sql command ident_current does? : Transact sql

537

What is data control language?

528

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3104

Name the different types of indexes in sql and define them.

565