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
- 68467 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / rupa
Select max(Marks) from Marks where Marks <
(select max(Marks)from Marks)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Does the unique constraint create an index?
What are sp_configure commands and set commands?
What is spid in sql server profiler?
How you can get a list of all the table constraints in a database? : Sql server administration
How to make conditional sum in ssrs?
What is side by side migration in sql server?
What is report snapshot?
Explain indexing and what are the advantages of it?
How to write an inner join with the where clause in ms sql server?
Explain sub-query?
What is the difference between set and select?
List down some advantages of sql stored procedure?
What do you understand by the analysis services in sql server?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
What is 3nf normalization form?
