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
- 67348 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
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
Different types of keys in SQL?
Is null in sql server?
What is the difference between lock, block and deadlock? : sql server database administration
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
Why do we backup Active Directory ?
How do I connect to sql server database?
ow to bring suspect mode datbase online from scratch
When would you prefer to have a minimum number of indexes?
Explain full-text indexing?
What is a heap?
what does the automatic recovery do? : Sql server administration
What is the difference between grant and with grant while giving permissions to the user?
How to add additional conditions in SQL?
