I have student marks in a student table. I need second
highest mark .Then what will the query for this?
Answer Posted / dolat ram
select max(mark) from student where mark < (select max
(mark) from student)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How to list all columns in a table using odbc_columns()?
What are Spatial data types in SQL Server 2008
What is transaction server implicit?
What is your recommendation for a query running very slow? : sql server database administration
What are different types of views?
What is a hint?
What is inline variable assignment?
Mention the different authentication modes in sql server.
How connect excel to sql server?
Which trace flags are enabled in sql server?
How to delete multiple rows with one delete statement in ms sql server?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
How to name query output columns in ms sql server?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
What is a data collection table?