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

Tell me what is normalization? Explain different forms of normalization?

0 Answers  

Explain what is sql server english query?

0 Answers  

How to run queries with sql server management studio express?

0 Answers  

what is a mixed extent? : Sql server administration

0 Answers  

can we have a nested transaction? : Sql server database administration

0 Answers  

Can we drop user if user mapped to any logins

1 Answers  

What is the partitioning method?

0 Answers  

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

Describe about first three Normal forms.

1 Answers   HP,

WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?

8 Answers  

What are xml indexes?

0 Answers  

Write a sql query to sort on different column name according to the parameters passed in the function?

0 Answers