Answer / sandeep

select top(1) a.salary
from

(
select top(2)sal
from
employee
order by salary desc
)a
order by a.salary asc

Answer / mark berlin.

REM solution #1:
select * from(
select distinct nvl(salary,-1) as sal
from employees
where nvl(salary,-1) < (select max(nvl(salary,-1)) from
employees)
order by nvl(salary,-1) desc)
where rownum=1;
REM Solution #2
select * from (
select distinct salary from employees
order by salary
desc
)
where rownum < 3
minus
select * from (
select distinct salary from employees
order by salary
desc
)
where rownum =1;

Answer / sushant hole

select max(salary) from employees where salary<(select max(salary) from
employees);

Answer / boby

select max(MAXI) from
(SELECT max(slno) AS MAXI FROM EMPLOYEE WHERE slno not IN(SELECT max(slno) FROM EMPLOYEE )
GROUP BY slno)a

Answer / naresh

select sal from emp e where 2= (select count(distntsal) from
emp y where e.sal<=y.sal);

Answer / neha singh

select min(sal)
from
(select sal from
(select sal from emp
order by sal desc)
where rownum<=2)

Answer / baburav zore

select max(sal) from employee where sal<(select sal from employee);

Answer / akshay

Select ename, eno, sal, rownum
from (select ename, eno, sal from emp order by sal desc)
where rownum = 2;

Answer / ahmad

Select Max(VacationHours) "MVacHrs"
from HumanResourcesEmployee
where VacationHours not in (Select Max(VacationHours)
from HumanResourcesEmployee)

Answer / google

Select min(sal) from emp where sal in (
select top 3 sal from emp
order by sal desc )

What is program debugging?

0 Answers  

what is try_catch block in procedure

0 Answers  

What are the packages in pl sql?

0 Answers  

SELECT emp_num, years, SUM(salary) FROM sales UNION ALL SELECT emp_id, SUM(takehomepay) FROM marketing What error is present in the sample code above? 1. Queries being combined with the UNION ALL statement are not allowed to have SELECT lists with a different number of expressions. 2. You are not allowed to use aggregate functions within two queries joined by a UNION ALL statement. 3. The UNION ALL statement incorrectly combines the "years" result from the first query with the "SUM (takehomepay)" result from the second query. 4. Unless the UNION ALL statement is replaced with a UNION statement, the queries will return duplicates. 5. The "emp_id" column from the second query must be renamed (or aliased) as "emp_num" so that it corresponds to the column name from the first query. Otherwise, the queries will not execute.

3 Answers  

how to enter characters as hex numbers? : Sql dba

0 Answers  

Explain table and field in sql?

0 Answers  

What is self-join and what is the requirement of self-join?

0 Answers  

What is trigger and stored procedure in sql?

0 Answers  

i have some prob lem to tell me about my self in interview first round ...

0 Answers  

What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.

3 Answers   TCS,

What is natural join in sql?

0 Answers  

i want to display 1 to 10 numbers using one select statement.

18 Answers   HCL, Nyros, Oracle,