In mySQL you can show a specific number of rows you would like to see by using the LIMIT clause. If you use LIMIT 0, 50 then it will return the first 50 rows, but if you have 14,500 records in a database, then you could use LIMIT 14450, 14500 and you will see that last 50 rows inserted into the database. Here's an example, I have 550 records in a database and I want to see the last 50:
-
SELECT a.pkid, a.call_id, a.log_cmpid, a.call_group, a.call_account, a.forwardno, a.callerno, a.caller_name, a.call_start, a.call_end, a.call_status, a.dispo, a.rating, a.revenue, a.assigned_to, a.ring_duration, a.answer_offset, a.inbound_ext, b.cmpname, b.cmpdescr, b.called_number, c.grpname, c.grpdescr, e.retname
-
FROM TBLcall_log a
-
LEFT OUTER JOIN TBLcall_cmp b ON b.cmpid = a.log_cmpid
-
LEFT OUTER JOIN TBLcall_group c ON c.grpid = b.cmpgrpid
-
LEFT OUTER JOIN TBLcall_account d ON d.accid = c.grpaccid
-
LEFT OUTER JOIN TBLretailer e ON e.retailerID = d.retailerID
-
WHERE 0=0
-
LIMIT 500, 550
If you need to do this by using something other than mySQL, then W3Schools has a great article here:
http://www.w3schools.com/Sql/sql_top.asp