Hello everyone.
guyz can you please help me in this query
id | name | lastname | status | hrs
1 qwe sss 1 5
2 rtyy zax 1 5
3 bvgf hyv 1 5
4 bvgd vbcf 1 10
5 cvxx hopy 1 10
6 bcxd loiu 1 10
now what i want to achieve is that......
first four records when hrs>1 or hrs<5 and last four records when hrs>5 and hrs< 10
and how can i manage same scenario when there will be lots of record
looking forward for your response
Regards