I have student marks in a student table. I need second
highest mark .Then what will the query for this?
Answer Posted / aaaa
SELECT * FROM `student` WHERE class='Six' ORDER BY mark DESC
LIMIT 1,1
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Are all views updatable ?
Explain what is “asynchronous” communication in sql server service broker?
What is the default order of an order by clause?
How to delete all rows with truncate table statement in ms sql server?
What are the differences between char and varchar in ms sql server?
What are the 2 types of classifications of constraints in the sql server?
Can another user execute your local temporary stored procedures?
What information is maintained within the msdb database?
Tell me what are the essential components of sql server service broker?
How to insert data into an existing table?
What is difference between join and natural join?
Mention the differences between having and where clause.
Does group by or order by come first?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
How many primary keys are possible in a table?