mysql how to display last 2 records for each customer

Question

I want to display last 2 records for each customer based on date, eg:

      id   |   name   |   date
       1   |    a     |  2015-10-11
       2   |    a     |  2015-09-11
       3   |    b     |  2015-10-10
       4   |    b     |  2015-09-01

I tried like

SELECT id,cust_id FROM ( SELECT id,cust_id @currcount := IF(@currvalue = cust_id, @currcount + 1, 1) AS cnt FROM customer ORDER BY id DESC) AS whatever WHERE cnt <= 2

but it displays all records

This question has been asked and answered several times on SO. — Shadow, Dec 11 '15 at 14:42

score 0 · Answer 1 · answered Dec 11 '15 at 14:38

0

SELECT * FROM ( SELECT * FROM table ORDER BY id DESC LIMIT 2 ) sub ORDER BY id ASC

This will select the last 2 rows from table, and then order them in ascending order.

answered Dec 11 '15 at 14:38

Muhammad Usman Ali Baloch

64
3
13

i dont want to last row i want 2 records for each customer – Ganesh Gudghe Dec 11 '15 at 14:40
You mean any two records, not necessarily last.then you can use following code. select * from customer LIMIT 2; – Muhammad Usman Ali Baloch Dec 11 '15 at 14:54
not any two records for each customer only 2 records – Ganesh Gudghe Dec 11 '15 at 14:55
check it: http://stackoverflow.com/questions/12113699/get-top-n-records-for-each-group-of-grouped-results – Muhammad Usman Ali Baloch Dec 11 '15 at 14:59

mysql how to display last 2 records for each customer

1 Answers1