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]