try using this... select top 1 from student where marks in (select top 2 f

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

Question Posted / kumaravel

Answer Posted / kumaravel

try using this...
select top 1 from student where marks in (select top 2 from
student order by marks desc)

Is This Answer Correct ?

16 Yes

10 No

Please Help Members By Posting Answers For Below Questions

What is the purpose of data source?

1089

What is the default value of an integer data type in sql server 2005?

994

How to loop through result set objects using mssql_fetch_array()?

1133

What is forward - only cursors / read only cursor?

1134

What are the various editions of sql server 2017 that are available in the market?

937

How do I create a partition table in sql server?

1182

How to create a new table in a given schema?

1254

What are the properties of the relational tables?

928

Do you know how to implement service broker?

967

What to perform pattern match with the like operator?

933

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1727

Explain the difference between functions and stored procedures in sql server?

1018

Do you know what are acid properties?

1122

What is cte (common table expression)?

1085

What is a livelock?

1016