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
- 69887 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / koti,khammam
select max(mark) from student where mark not in (select max
(mark) from student)
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is data modification?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
What is lookup override?
Define Wed Edition in SQL Azure?
What is an execution plan?
What is a deadlock and what is a live lock?
Can you pass expressions to stored procedure parameters?
Write a SQL command to insert and update only a particular field?
What is partition index 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 the use of “join” in sql server?
What is mssql?
What happens if we shrink log file in sql server?
What is a unique index?
Can sql servers link to other servers?
