I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 61306 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
What are the different types of collation sensitivity in sql server?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
What are the steps to process a single select statement?
Which are the olap features?
What are types of subqueries?
What is use of dbcc commands?
What is normalization of database?
Why truncate is ddl command?
Explain about service Broker functions?
What is federation member?
What are the tables in sql?
How to use subqueries in the from clause in ms sql server?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
What’s the use of custom fields in report?
