MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


5.7.29


CREATE TABLE sales (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
serial_no VARCHAR(30) NOT NULL,
card_amt int(6),
pos_no VARCHAR(50)
);

INSERT INTO sales(id, serial_no,card_amt, pos_no) 
VALUES('1','100','10','PS1'),('2','101','10','PS1'), 
('3','103','10','PS1'), ('4','107','10','PS1'),('5','108','10','PS1'), ('6','109','10','PS1'),
('7','111','10','PS1'),('8','200','10','PS2');
select * from sales;


id
serial_no
card_amt
pos_no


1
100
10
PS1

2
101
10
PS1

3
103
10
PS1

4
107
10
PS1

5
108
10
PS1

6
109
10
PS1

7
111
10
PS1

8
200
10
PS2

id	serial_no	card_amt	pos_no
1	100	10	PS1
2	101	10	PS1
3	103	10	PS1
4	107	10	PS1
5	108	10	PS1
6	109	10	PS1
7	111	10	PS1
8	200	10	PS2

id	serial_no	card_amt	pos_no
1	100	10	PS1
2	101	10	PS1
3	103	10	PS1
4	107	10	PS1
5	108	10	PS1
6	109	10	PS1
7	111	10	PS1
8	200	10	PS2

id	serial_no	card_amt	pos_no
1	100	10	PS1
2	101	10	PS1
3	103	10	PS1
4	107	10	PS1
5	108	10	PS1
6	109	10	PS1
7	111	10	PS1
8	200	10	PS2