select * from student where mark=(select max(mark) from student where mar

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

Question Posted / b.bathakaraithangam,giri

Answer Posted / b.bathakaraithangam,giri

select * from student where mark=(select max(mark) from
student where mark not in (select max(mark) from student))

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can two tables have the same primary key?

1201

What command is used to rename the database?

1007

What are the diifferences between the ms sql server vs mysql?

1170

Tell me about pre-defined functions of sql?

1107

What is etl - extraction, transformation, and loading?

917

What are four major operators that can be used to combine conditions on a where clause?

1040

Do you know what is replace and stuff function in sql server?

1006

What languages bi uses to achieve the goal?

1002

How to connect a database with sql express.?

1058

Describe different Processing Modes offered by SSRS?

248

Explain about system stored procedure?

1031

Define left outer join in sql server joins?

958

1 01 101 01010

2050

Why truncate is ddl?

1084

Explain the steps to create and execute a user-defined function in the sql server?

963