I have student marks in a student table. I need second
highest mark .Then what will the query for this?
Answer Posted / appalanaidu
select max(marks) from studentmaster where marks < (select max(marks) from studentmaster)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is indexing in sql server with example?
What is the difference between ddl,dml and dcl commands?
What is SQL Server?
What is a covered index?
What are data files?
What is reference section?
How to defragment table indexes?
What number sorts of privileges are accessible in sql?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
What are the five major components of a dbms?
What are the three different part of rdl file explain them?
What do you understand by replication in sql server?
How to drop an existing table?
Explain about sql server login?
What happens if you delete a table that is used by a view?