We have 100 records in table how to fetch 10 th record?

Answer Posted / victor

You can use the limit in mysql :)

SELECT * FROM table LIMIT 9, 1;

Is This Answer Correct ?    0 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between hashed & sorted internal tables?

1633


What are the dynapro keywords?

669


What are field symbols?

640


What is table pool?

579


Event handling in oops

1126






What are the differences between a database index and a match code? : abap data dictionary

651


What is img? : sap abap hr

700


What is the collect statement? How is it different from append?

522


How do you find if a logical database exists for your program requrements?

605


Explain the advantages and disadvantages of abap query tool?

520


How do you control printer functions from sapscript?

704


Why do we need enhancements?

632


What is the difference between rfc and bapi function modules? : abap bdc

630


what are the two methods of modifying sap standard tables? : abap data dictionary

626


hi I am in training of functional module, i am unable to understand what exactly use of IDOC,BAPI,DIM and BIM. As LSMW and BDC methods are used for data conversion from legacy to sap. Might be it is silly question. please explain me

1771