I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 61301 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / jyoti bikash panda
select a.marks from student a where(select count(b.marks)
from student b where a.marks<=b.marks)=2
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Name 3 ways to get an accurate count of the number of records in a table?
Explain temporary table vs table variable by using cursor alternative?
What happens to a statement batch if there is a compilation error?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
How do I connect to sql server database?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
Can you index views?
List the different normalization forms?
Comment,Datatypes are unlimited
How to generate create table script on an existing table in ms sql server?
What is an expensive query?
How much space does sql server 2016 take?
System variable and temporary variables
What is default constraint in ms sql server?
Why transaction is important?
