I have student marks in a student table. I need second
highest mark .Then what will the query for this?
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
How to copy the tables, schema and views from one sql server to another?
Explain filestream storage of sql server 2008?
What is log ldf?
How do I delete a sql server database?
What is #table in sql server?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
What is the difference between char, varchar and nvarchar?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
What is BLOCK statements in SQL?
Explain about analysis services?
How to execute a sql statement using odbc_exec()?
Where can you find the error log information? : sql server database administration
How can you start sql server in different modes?
What is join and name different type of joins?
What is the difference between a primary key and a unique key? Are they the same?