I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 62831 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
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
What command would you use to add a column to a table in sql server?
What is the sql server 2000 version number?
Where do we use trace frag?
How to update values in a table with update statements in ms sql server?
Write a program to fetch first 10 records from a file?
How you can change a cross join into an inner join?
What is open database communication (odbc)?
What are the advantages to use stored procedures?
How to check status of stored procedure in sql server?
Do you know what is a with(nolock)?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
Is foreign key unique?
What is CTE in SQL
Explain different types of lock modes in sql server 2000?
How to view existing indexes on an given table using sp_help?
