Answer / jyoti bikash panda

select a.marks from student a where(select count(b.marks)
from student b where a.marks<=b.marks)=2

Answer / dinesh gupta

4th highest salary

SELECT * FROM(
SELECT ROW_NUMBER() OVER (ORDER BY
grosssalary desc) AS salaryno , *
FROM (
select distinct grosssalary
from salarydetails where inmon='dec' and inyear = 2007
) as a
) As T
WHERE t.salaryno = 4

3rd lowest salary

SELECT * FROM(
SELECT ROW_NUMBER() OVER (ORDER BY
grosssalary ) AS salaryno , *
FROM (
select distinct grosssalary
from salarydetails where inmon='dec' and inyear = 2007
) as a
) As T
WHERE t.salaryno = 3

Answer / aaaa

SELECT * FROM `student` WHERE class='Six' ORDER BY mark DESC
LIMIT 1,1

Answer / vikas kant

select Top 1 marks from students where marks in(select Top
2 marks from students order by marks desc)

Answer / appalanaidu

select max(marks) from studentmaster where marks < (select max(marks) from studentmaster)

Answer / dolat ram

select max(mark) from student where mark < (select max
(mark) from student)

Answer / sarika

select max(mark)
from student
Having max(mark)<(select max(mark)
from student)

Answer / maheswar reddy s

select top 1 * from (select top 2 marks from student order by marks desc)a order by marks

Answer / devi

Get data to internal table from database table using select query.
Sort the second internal table by ascending order.
Then use Delete adjacent duplicates comparing highest marks.
It will remove duplicate highest marks.
Then sort the internal table by descending order.
Read internal table into workarea index 2.
It will give the second highest mark.

Some times we have to process more steps using all data's. At that time we have to create two internal table with same structure . Move the data from firs table to second table and do the above steps.

Answer / ahmed

SELECT TOP 1 student marks
FROM(
SELECT TOP 2 student marks
FROM students_table
ORDER BY student marks DESC) AS emp
ORDER BY student marks ASC;

How can we use ConnectorJ JDBC Driver with MS SQL?

0 Answers   PUCIT,

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

0 Answers  

what do you understand by change data capture?

0 Answers  

How do you open a cluster administrator?

0 Answers  

What is database isolation in sql server? : sql server database administration

0 Answers  

What is lookup override?

0 Answers   Informatica,

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

Why do we use sql limitations? Which constraints can we use while making a database in sql?

0 Answers  

Explain linked server in sql?

0 Answers  

What is the difference between DTS and SSIS?

3 Answers   Allianz,

What are views in ms sql server?

0 Answers  

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 Answers