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
- 68466 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / devi
Get data to internal table from database table using select query.
Sort the second internal table by ascending order.
Then use Delete adjacent duplicates comparing highest marks.
It will remove duplicate highest marks.
Then sort the internal table by descending order.
Read internal table into workarea index 2.
It will give the second highest mark.
Some times we have to process more steps using all data's. At that time we have to create two internal table with same structure . Move the data from firs table to second table and do the above steps.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is spatial nonclustered index
How you trouble shoot when any job fails
What are the extra roles available in msdb? : sql server security
What is primary key index?
How will you make an attribute not process? : sql server analysis services, ssas
what is the maximum size of a row? : Sql server database administration
What is ms sql server index?
What is function of ROLLUP ?
Explain transaction server consistency?
What do you mean by cardinality?
What is for xml in sql server?
Which rendering formats are affected by the pagesize properties?
What are the encryption mechanisms in sql server?
Explain different types of Normalization.
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
