I have student marks in a student table. I need second
highest mark .Then what will the query for this?
Answer Posted / shrikant
I have student marks in a student table. I need all record
where second highest mark .Then what will the query for this?
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the full form of dql?
How do we know if any query is retrieving a large amount of data or very little data?
How self join is different from outer join?
Suggest a method of joining two tables.
Explain Reporting Life Cycle?
what do you understand by change data capture?
what information is maintained within the msdb database? : Sql server administration
What is filtered index?
In what sequence sql statement is processed?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What is the purpose of forms?
When columns are added to existing tables, what do they initially contain?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
Explain what are magic tables in sql server?
Can we call stored procedure in trigger?