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

Explain how do you use structures in the abap programs?

532


How to give programe name as input in BDC report of abap ?

1718


What are the tcodes for performance tuning?

899


What are domains and data element? : abap hr

595


Define database layer? : abap data dictionary

665






Explain buffering concept usage?

587


could anyone tell me what r real time questions been asked in interviews?i am in urgent need..thanks in advance

1435


In SAP Script,How to display a single field(like matnr)at the right end of the form.

1972


What is the difference between call transaction method and the session method? : abap bdc

528


What are the fields in a bdc_tab table? : abap bdc

606


How many types of size categories and data classes are there?

614


What are the update types possible? : abap data dictionary

551


Explain the differences between interactive and drill down reports?

506


What is structure?

563


Can you print decimals in type n?

562