Answer / pramod janjirala

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

Answer / chandu

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

Answer / ram

select sal as Max_sal, ename from emp where sal
IN( select max(sal) from emp);






sun_ramprasad@yahoo.com

Answer / suresh naik

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

Answer / pramod janjirala

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

Answer / kavitha

select ename,sal
from employees
where rownum <=1
order by sal desc

Answer / manoj k

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

Answer / nagendra

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

Answer / selvaraj v , anna university c

select ename, salary from emp where salary=(select max
(salary) from emp) order by emp_no;

Answer / santosh

select ename,sal
from emp
where sal = (select max(sal) from emp)
and rownum<= 1

What is dynamic SQl and how you will create and execute dynamic sql?

2 Answers   TCS,

how to create a primary key with out creating an index?

9 Answers   TCS,

what is cursor procedure

1 Answers   iGate,

Explain exception handling in pl/sql?

0 Answers  

oracle is compiler or interpretter,can any one tell me the answer?

9 Answers   Satyam,

how u can find the n row from a table?

19 Answers   Tech Mahindra,

What is a design view?

0 Answers  

Can we insert data into materialized view?

0 Answers  

What are synonyms in sql?

0 Answers  

Can you have multiple SPs with the same name on a database?

2 Answers   CGI, Quest,

how to achieve this problem?i am having table with two colums like empno,gender. in gender column, i am having records male,female like that .my final output will be male female 5 6

4 Answers   Hexaware,

What is difference between sql and mysql?

0 Answers