I have student marks in a student table. I need second
highest mark .Then what will the query for this?
Answer Posted / suman
select max(mark) from student where mark <
(select max(mark)from student)
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
What are logical/boolean operations in ms sql server?
What are the types of processing and explain each? : sql server analysis services, ssas
How to filter records of table in SQL SERVER?
How to delete existing triggers using "drop trigger"?
How use inner join in sql server?
What is blocking and how would you troubleshoot it? : sql server database administration
How to start sql server browser service?
How to populate a table in sql server?
Can we write ddl in trigger?
wat wil hapn if we give the both read and deny read permission to user?
How do I edit a procedure in sql server?
Why use triggers?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
What is difference between rownum and row_number?
How to make a remote connection in a database?