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
- 68510 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / vk
select studentid,student_name,marks from
(select row_number() over (partition by marks order by marks desc) as rnk,studentid,student_name,marks from student_marks)
where studentid in (1,4);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What command would you use to add a column to a table in sql server?
What is user-defined function?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
What is transaction server consistency?
Where are full-text indexes stored?
What are examples of triggers?
In what version of sql server were synonyms released?
What is the use of floor function in sql server?
Where are SQL server users names and passwords are stored in sql server?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
Do you know how to make remote connection in database?
What is the use of sql profiler in sql server 2012?
Can you please differentiate between a primary key and a unique key?
Explain full-text indexing?
How to optimize stored procedure optimization?
