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
- 69876 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / vikas kant
select Top 1 marks from students where marks in(select Top
2 marks from students order by marks desc)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
how to take backup bcp out for a column in table in sql server?
How to create a stored procedure with a statement block in ms sql server?
What is measure group, measure? : sql server analysis services, ssas
What is the maximum length of an alert name?
what are the disadvantages of cursors? : Sql server database administration
Can sql servers link to other servers like oracle?
Equi join and non equi join is possible with sql server?
Explain system functions or built-in functions? What are different types of system functions?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
Tell me what is de-normalization and what are some of the examples of it?
Explain what is it unwise to create wide clustered index keys?
What are the different types of join?
What do you mean by 'normalization'?
Will the writetext statement activate a trigger?
Is truncate a dml command?
