Answer / siva kumar yachamaneni

select max(salary) from Employee where salary<(SELECT
max(salary) from Employee)

Answer / prabir

Select * From employee emp1 Where 2 = (Select
Count(Distinct(emp1.salary)) From employee emp2 Where
emp2.salary > emp1.salary)

Answer / shasi

select sal from emp a where &n=(select count(sal) from emp
b where a.sal>=b.sal)
First u enter 1 means 1st highest sal.then enter2 2nd
highest sal

Answer / ashish raut

for 2nd highest price..............

SELECT max(Price) as [MaxPrice] from OrderDetails
where Price<(SELECT max(Price)as MaxPrice from OrderDetails)

for 3rd highest Price........

SELECT max(Price) as [MaxPrice] from OrderDetails
where Price<(SELECT max(Price)as MaxPrice from OrderDetails
where price<(SELECT max(Price)as MaxPrice from OrderDetails))

Answer / praveen

select * from emp where max(sal)
where rownow=2

Answer / apurva

Select *
From (
Select *
From (select * from emp order by sal desc)
Where rownum < 3 order by sal) ---> n+1 for example for
secound you should use 3
Where rownum < 2

Answer / sachin bhalsinge

select * from (select salary from employees order by salary
desc)where rownum=2;

Answer / ramesh.p

Select salary
From ( Select salary from emp order by salary desc)
Where rownum =2;

Answer / siddhartha

select sal, ename from employee where ROWNUM = 2 order by
sal;

how to rename an existing column in a table? : Sql dba

0 Answers  

What are the uses of merge?

0 Answers  

Display the total debit counts, total credit counts, sum of total debits, sum of total credits from an employee's transaction table (a single table) containing the following columns. Transaction_number Transaction_amount Transaction_date Transaction_type --> tells if the amount is a credit or a debit. As the query alone is important, the table is left with specifying just the field's name. Pls help me with this query.

3 Answers   iNautix, Oracle,

How run sql*plus commands that are stored in a local file?

0 Answers  

what is self join and why is it required? : Sql dba

1 Answers  

What are the different ddl commands in sql?

0 Answers  

What is the difference between count 1 and count (*) in a sql query?

0 Answers  

What is procedure in pl sql?

0 Answers  

how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c

8 Answers   Oracle,

How insert into statements in sql?

0 Answers  

Does sap use sql?

0 Answers  

Where is sql database stored?

0 Answers