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
- 68516 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sanah
select top 1 marks from marks where marks
<(select max(marks) from marks) order by 1 desc
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What factors you will consider calculating the storage requirement for that view?
In how many ways you can invoke ssrs reports?
Explain Geography datatype in SQL Server
How do you run a trace?
What is the function of sql server agent windows service?
What are different types of collation sensitivity?
How to add a new dsn with the odbc driver for sql server?
Can a table be moved to different filegroup?
Define views.
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
Tell me what is fill factor?
In case you have filters in your report, when filters will be applied in cached report instance?
Give a example to search fr a string in all stored procedure in sql server.
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
