Interested to Buy Any Domain ? << Click Here >> for more details...
I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 68689 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / vikas kant
select Top 1 marks from students where marks in(select Top
2 marks from students order by marks desc)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How secure is sql server database?
Can you edit the .rdl code associated with a linked report?
What are the types of joins in sql?
please differentiate between delete and truncate?
Do you know how to store and query spatial data?
What is function of ROLLUP ?
What is bit data type? What's the information that can be stored inside a bit column?
How do I create a stored procedure in dbml?
What is exporting utility?
What are the different subsets of sql?
How to use subqueries with the in operators in ms sql server?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How many triggers are possible per table?
do views contain data ?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
