I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 62934 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / kunal sain
select mark from student s
where 1=(select count(*) from student s1
where s1.mark<s.mark);
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
How to transfer an existing table from one schema to another schema in ms sql server?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
How to provide default values to stored procedure parameters?
What is the recommended total size of your memory optimized tables?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is store procedure? How do they work? When do you use?
Explain about integration services of Microsoft SQL server?
What are the three different part of rdl file explain them?
What is report rendering ?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
What are the pre-defined functions in the sql server?
What are the recovery models for a database?
What is isolation levels?
What does ss stand for sexually?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
