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
- 68731 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / madan
This ans. particularly when you want 2nd highest marks?
and not for nth highest marks.
SELECT MAX(mark) FROM student WHERE mark <
(SELECT MAX(mark)FROM student)
| Is This Answer Correct ? | 18 Yes | 7 No |
Post New Answer View All Answers
New concepts of sql server 2005 use in your project.
Which are the two editions in which SQL Azure database available?
How will you go about resolving deadlocks?
What will be the maximum number of index per table?
What is database isolation in sql server? : sql server database administration
how to determine the service pack currently installed on sql server? : Sql server database administration
What is a non-clustered index?
What is the purpose of the master database?
Explain optimistic and pessimistic concurrency?
How to change the password of a login name in ms sql server?
Explain different types of locks in sql server.
What are different type of Collation Sensitivity?
What is tcl in sql server?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What is GUID in sql server?
