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 are all the different normalizations? : Sql dba

0 Answers  

declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?

3 Answers   Oracle,

after tell procedure whole code he asked can i write the same way in a function

3 Answers  

Types of joins?

4 Answers   Microsoft,

Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?

5 Answers  

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

0 Answers  

What is a procedure in pl sql?

0 Answers  

Is ms sql is free?

0 Answers  

declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....

3 Answers   Satyam,

Does mysql support pl sql?

0 Answers  

Which is better stored procedure or query?

0 Answers  

What is package in pl sql?

0 Answers