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
- 67293 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / pravin more
select max(mark) from student where mark <
(select max(mark)from student)
| Is This Answer Correct ? | 53 Yes | 14 No |
Post New Answer View All Answers
How to defragment indexes with alter index ... Reorganize?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
How many partitions a clustered index has by default in sql server 2012?
how you can deploy an ssrs report?
Which sql server table is used to hold the stored procedure scripts?
Where do we use trace frag?
How to create an identity column?
What do you understand by a stored procedure?
What is a rownum?
Can we use pragma autonomous_transaction in trigger?
What is the chart in report?
Is foreign key unique?
How many types of built in functions are there in sql server 2012?
What are the types of processing and explain each? : sql server analysis services, ssas
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
