I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 62927 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / appalanaidu
select max(marks) from studentmaster where marks < (select max(marks) from studentmaster)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is usually the first word in a sql query?
What is the cpu pressure?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
What is a database table?
What is the default Port No on which SQL Server listens?
What is a print index?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
Explain isolation levels that sql server supports?
What are the differences between union, intersect, and minus operators?
How many replicas are maintained for each SQL Azure database?
What is create statement?
tell me the disaster recovery plan
Can we use trigger new in before insert?
What stored by the msdb? : sql server database administration
Which data type columns are the best candidates for full-text indexing?
