SELECT TOP (1) stuMark FROM Student WHERE stuMark

I have student marks in a student table. I need second
highest mark .Then what will the query for this?

Question Posted / siva prakasam

Answer Posted / siva prakasam

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

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Explain about system stored procedure?

598

How can you manage sql azure security?

how to create “alternate row colour”?

109

How does normalization work?

504

How can we solve concurrency problems?

568

What stored procedure would you use to view lock information?

528

How do we Backup SQL Azure Data?

How many instances per computer are there in sql server 2000?

580

Write SQL queries on Self Join and Inner Join.

615

Can you pass expressions to function parameters?

541

Define self join?

629

What is a data source or ds? : sql server analysis services, ssas

565

Can one drop a column from a table?

552

Explain primary key in sql server?

568

What is the difference between for xml raw and for xml auto?

566