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
what is the difference between Tabular and Matrix report?
What is the difference between functions and scalar functions?
How to include date and time values in sql statements?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
What’s the use of custom fields in report?
What do you mean by cardinality?
Where do we use trace frag?
How to copy data from one table to another table?
What is meant by dirty read?
Can we insert data into view sql server?
Describe and explain about SQL native client?
How to specify the collation for a character data type in ms sql server?
What is intellisense?
Explain acid?
What is surrogate key? : sql server analysis services, ssas