Answer / pravin more

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

Answer / madan

This ans. particularly when you want 2nd highest marks?
and not for nth highest marks.

SELECT MAX(mark) FROM student WHERE mark <
(SELECT MAX(mark)FROM student)

Answer / kumaravel

try using this...
select top 1 from student where marks in (select top 2 from
student order by marks desc)

Answer / sanjay

create table test(id int identity,marks int)
insert into test
select 20
union all
select 31
union all
select 33
union all
select 1
union all
select 3
union all
select 100
union all
select 88

select * from test


with data as
(
select marks,row_number() over(order by marks desc) as rno
from test
)
select * from data where rno = 3

Answer / supriya

select max(marks) from student where marks not in (select
max(marks) from student)

Answer / ravindra singh

select b.marks from (select distinct marks from student)
a,(select distinct marks from student) b
where a.marks >= b.marks
group by b.marks
having count(b.marks)=3

Answer / naresh

select top 1 age from student where age<(select top 1 age
from student where age<(select distinct max(age) from
student ))

Answer / rakesh

In Oracle

select marks from
(select marks from
(select marks from students order by marks desc)
where rownum<3
order by marks asc)
where rownum<2

Answer / suman

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

Answer / siva prakasam

SELECT TOP (1) stuMark
FROM Student
WHERE stuMark < (SELECT MAX(stuMark) FROM Student)
ORDER BY stuMark DESC

What are the main control-of-flow T-SQL constructs?

1 Answers  

How to delete database objects with "drop" statements in ms sql server?

0 Answers  

How would you choose between a clustered and a non-clustered index?

0 Answers  

What happens when unicode strings concatenate with non-unicode strings?

0 Answers  

What are null values in ms sql server?

0 Answers  

Explain the steps to use transact-sql cursor?

0 Answers  

Explain mixed authentication mode of sql server?

0 Answers  

What is the diff between Static Queries and Dynamic queries give me some examples

2 Answers   CSC,

What is abstracting periodical?

0 Answers  

What is the maximum length of an alert name?

0 Answers  

can any one please send sql quries most used in applications.

2 Answers  

What is the use of placing primary key and foreign key constrains on columns.

4 Answers   Value Labs,