CODEWITHSUNDEEP
phpmysql
WajidAfaneh
WajidAfaneh

Reputation: 59

Returning the last two set of records mySQL

well, i'm new to MySQL Database and i got a problem, i need to get the last two set of records from a table ( the records are automatically added to this table every week) i need to use to find the growth that an entity did during the last week.

can any one help plz.

here is what i wrote, i tested it on my local host and it worked :D, but when we installed it online, it crashed :(

select pages.*, new.* from (
select id, tableone.page_id, one, two,(two - one) as diff from 
(SELECT id, page_id, likes as two FROM `page_records` WHERE id IN ( SELECT max( id )    FROM `page_records` GROUP BY page_id )) as tableone left join 
(SELECT page_id , likes as one  FROM `page_records` where id in ( SELECT max(id) FROM   `page_records` where id not in (select max(id) from `page_records` group by page_id) group      by page_id))
as tabletwo 
on tableone.page_id = tabletwo.page_id 
order by tableone.page_id asc) as new inner join pages on pages.id = new.page_id

Thanks in advance.

Upvotes: 0

Views: 73

Answers (2)

Anand Solanki
Anand Solanki

Reputation: 3425

Try this:

SELECT * FROM table_name 
ORDER BY id DESC 
LIMIT 0, 2

Thanks!

Upvotes: 0

Jelle Ferwerda
Jelle Ferwerda

Reputation: 1229

try: SELECT id, page_id, likes FROM page_records order by id desc limit 0, 2

Upvotes: 2

Related Questions