Interested to Buy Any Domain ? << Click Here >> for more details...
I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 69889 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / lokeshwaran s
SELECT MAX(marks) AS second_highest_mark
FROM student
WHERE marks < (SELECT MAX(marks) FROM student);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Write a sql query to sort on different column name according to the parameters passed in the function?
what authentication modes does sql server support? : Sql server database administration
Explain the concepts and capabilities of sql server?
What does it mean to normalize a database and why would you do it?
How is SQL Azure different than SQL server?
What is log ldf?
How many triggers you can have on a table?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
What are basics of policy management?
How to start sql server browser service?
What is the function of inner join?
What is isolation levels?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Explain what you mean by 3 tier architecture.
What is provisioning, billing and metering, and connection routing concepts in the service layer?
