I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 61293 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / suman
select max(mark) from student where mark <
(select max(mark)from student)
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
What is inline table-value user-defined function?
What is the cpu pressure?
Explain temporary table vs table variable by using cursor alternative?
How do I debug a stored procedure in sql server?
How to connect php with different port numbers?
Explain the advantages of merge replication?
How to loop through result set objects using odbc_fetch_row()?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
Why can there be only one clustered index and not more than one?
query processing
What is sql azure database?
Do you know what is difference between stored procedure and user defined function?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
What are the different types of Indexes available in SQL Server?
Working with TLogs
