I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 61312 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / koti,khammam
select max(mark) from student where mark not in (select max
(mark) from student)
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is a join in sql?
Why do we backup Active Directory ?
What is the purpose of grouping data in a report?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
How to defragment table indexes?
Which table keeps information about stored procedures?
Explain DBCC?
How dts is used to extract, transform and consolidate data?
What are the purposes of floor and sign functions?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
What are dml (data manipulation language) statements in ms sql server?
what are different types of raid configurations? : Sql server database administration
Explain why variables called the most powerful component of ssis?
How many types of functions are there in sql server?
What is a partitioned view?
