Answer / shivaprasad

Hi Every one,this query will helps you to find 1st or 2nd or
3rd or and so on salary from the employee table.

change inside distinct top (3) for respective results

select distinct top 1 Salary from(select distinct top 3
Salary from Employee order by Salary DESC)temp order by
Salary;

Answer / narendra

select max(company_id) from company where company_id <
(select max(company_id) from company where company_id <
(select max(company_id) from company))

Answer / sabapathi

select sal from employee
where sal=(select min(sal) from employee
where sal>(select min(sal) from employee
where sal>(select min(sal) from employee)))

Answer / mohd. rashid

SELECT TOP 1 salary
FROM(
SELECT DISTINCT TOP 3 salary
FROM employee
ORDER BY salary DESC)
ORDER BY salary

Answer / ravindra

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

Answer / santhoshkumar

select name,salary from emp where salary=(select min(sal)
from (select distinct TOP 3(salary) from emp order by
salary desc;

Answer / ram pravesh

select max(sal) from emp where sal<(select max(sal)from emp
where sal<(select max(sal) from emp))

Answer / pardeep kumar

This is the Simplest One
Let i have a Column named EmpSal in Tbale Named tbEmp


Select Min(EmpSal) from tbEmp where EmpSal IN(Select
Distinct Top 3 EmpSal from tbEmp ORDER BY EmpSal DESC)

Answer / ashok naik

In Sql server:
Select top 1 ThirdHighest.salary from(
Select distinct top 3 salary from employee order by salary
desc) as ThirdHighest

--example for 4th highest salary in above query put 4
inplace of 3

--example for 5th highest salary in above query put 5
inplace of 3
--and so on for nth highest

Answer / harikrishna ravipati

select max(sal) from emp where sal <
(select max(sal) from emp where sal <
(select max(sal) from emp))

what are the advantages of running a database in archive log mode?

0 Answers  

If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X

2 Answers  

I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?

1 Answers  

In Oracle 10g, "g" Stands for what?

5 Answers   Mphasis,

How to create a table index in oracle?

0 Answers  

Explain the use of full option in exp command.

0 Answers  

How to rename an existing table?

0 Answers  

What are advantages fo Stored Procedures?

1 Answers  

How to estimate disk space needed for an export job?

0 Answers  

I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?

2 Answers   Zensar,

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

1 Answers   Oracle,

What is system tablespace?

0 Answers