I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 61310 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
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 ssl in sql server?
What is sqlcmd?
What is normalization of database?
What is the function of sql server agent windows service?
How to define the name and server for a new dsn?
How can you set the threshold at which sql server will generate keysets asynchronously?
What information is maintained within the msdb database?
How you can find out if an index is useful to the optimizer?
What is filter index?
What are the advantages of passing name-value pairs as parameters?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
Explain datetime2 data type in sal server 2008?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What is the use of stored procedure?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
