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
- 67342 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / poomanibe
with temptab as
(
select row_number() over(order by substring(marks,1,2)) as
rownum,* from Student
)
select * from temptab where rownum=1
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Which table keeps the locking information?
Can you explain what is the use of custom fields in report?
How real and float literal values are rounded?
What are page splits? : SQL Server Architecture
Explain primary key, foreign key and unique key?
whats new about truncate in sql server 2008?
Explain the functionalities that views support?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
What is an example of a primary key?
What is view in sql?
Explain the various types of concurrency problem?
What is isolation levels?
What is inner join? Explain with an example?
How do users use Report Builder with SQL Server data sources?
how would you troubleshoot blocking? : Sql server database administration
