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

How to run sql statements through the web interface?

728

What is difference between pls_integer and integer?

703

Which is faster view or stored procedure?

688

Why do we use partitions in sql?

718

Why self join is used in sql?

679

What is the sql case statement?

746

How do I install microsoft sql?

710

how to include numeric values in sql statements? : Sql dba

768

What is sql prepared statement?

735

How do I debug a stored procedure?

811

What is dba in sql? : SQL DBA

738

How to create your own reports in sql developer?

729

Can you have more than one key in a database?

684

when MSQL8.0 is in market

1772

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

751