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
- 69890 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
Tell me can we use custom code in ssrs?
What are the purpose of Normalisation?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
What is a bit datatype?
What are the fixed server level roles? : sql server security
How to connect Azure federated root database and apply federation in entity framework?
What are the benefits and tasks of object explorer? : sql server management studio
What is Command line parameters in PLSQL.?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What is named calculation? : sql server analysis services, ssas
What are the pre-defined functions in the sql server?
What is the difference between Normalization and De-normalization?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
How to create a user name in a database?
Define Business Edition in SQL Azure?
