To select row 10 to 30 below query might be useful select * from mytable limit 10,20;
The query will list 11th record to 30th record.
N. Kavithashree wrote:
hello,
ususally we use :
select * from table limit 50;
This will display the rows which were entered first the table created (i..e, that end);
if i wnat to select from the other side then what should i use ?
if there is a serial no column like id or some autoincremt column or DATE then we can query on desc order or date wise .
other than that if i hv just 2-3 fields in my table(name, city,phone). i want to retrieve the records from top end (oldest 10) or from the other end (latest 50) ----------How to select then?
i also want anybody to tell if they know : is there any way to select from particular row no to other....eg. row 10 to row 30 ? like this?
==================================================== N. Kavithashree ===================================================
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
