I have student marks in a student table. I need second
highest mark .Then what will the query for this?
Answer Posted / pravin more
select max(mark) from student where mark <
(select max(mark)from student)
| Is This Answer Correct ? | 53 Yes | 14 No |
Post New Answer View All Answers
How do I know if localdb is running?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
What is the use of floor function in sql server?
What is update locks?
what is an extended stored procedure? : Sql server database administration
How can we rewrite sub-queries into simple select statements or with joins?
Why use update_statistics command in sql server?
Explain the steps to use transact-sql cursor?
If a table does not have a unique index, can a cursor be opened on it?
What is the difference between delete and truncate statements?
What do you need to connect php to sql server?
Can you name a few encryption mechanisms in sql server?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
Explain logical operators in sql server?
Is there any difference between primary key and unique with the not null condition?