select top 1 * from (select top 2 marks from student order by marks desc)a

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

Question Posted / maheswar reddy s

Answer Posted / maheswar reddy s

select top 1 * from (select top 2 marks from student order by marks desc)a order by marks

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a trace frag? Where do we use it?

1100

If a table does not have a unique index, can a cursor be opened on it?

915

Explain something about security and SQL Azure?

134

Where are stored procedures in sql server?

1065

Is null vs coalesce?

882

What is sql azure database?

206

What are the database roles? : sql server security

1188

Define full outer join?

955

How would we use distinct statement? What is its use?

1072

What does it mean to manipulate data?

992

What is a transactions?

1039

Differentiate between a local and a global temporary table?

954

Explain transaction server explicit transaction?

930

What is cursors? And what are the different types of cursor?

1144

What is the purpose of linked server configuration in sql server?

1048