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

WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...

2 Answers   TVS,

What samples and sample databases are provided by microsoft?

0 Answers  

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

2 Answers  

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

0 Answers  

Tell me the difference between clustered and non-clustered index?

0 Answers  

How can a database be repaired?

0 Answers  

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers  

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

0 Answers  

What are the properties of the relational tables?

0 Answers  

What is sql server management studio? : sql server management studio

0 Answers  

What are different types of Keys? Please explain all the keys with a suitable example.

4 Answers  

How many categories of data types used by sql server?

0 Answers