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

wat is tuff file in log shipping, wt is d use of tht file?

1 Answers   TCS,

What is DAC? what is the use of it?

1 Answers   Wipro,

what is the difference between delete,drop and truncate

2 Answers   Honeywell, Zomato,

How to encrypt Strored Procedure in SQL SERVER?

0 Answers  

What is scan table/view and seek table/view when its occurs? : sql server database administration

0 Answers  

What is data modification?

0 Answers  

What methods do you follow to protect from sql injection attack?

0 Answers  

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

17 Answers   HCL, IBM,

HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY IN EMP TABLE

18 Answers   Infosys, TCS,

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

0 Answers  

What are the differences between decimal and float in ms sql server?

0 Answers  

What is cross join in sql server joins?

0 Answers