Counting TOP 4 rows from SQL after the first TOP 4 rows

Question

I want to display the records which occur in row number 5, 6, 7 and 8 (4 results) excluding the TOP 4 in descending order. Currently I tried using SELECT * FROM estate_ad_listing WHERE eal_id != TOP (4) ORDER BY eal_id DESC LIMIT 4 but I am getting error. I am using PDO. Please help.

My query:

$sal = "SELECT * FROM estate_ad_listing WHERE eal_id != TOP (4) ORDER BY eal_id DESC LIMIT 4";
$wur = $PDO->prepare($sal);
$wur -> execute();

give me an example with my query – Shubham Jha Mar 18 '16 at 07:09 — Shubham Jha, Mar 18 '16 at 07:09
Can you post the what error is that? – rmondesilva Mar 18 '16 at 07:10 — rmondesilva, Mar 18 '16 at 07:10

score 3 · Accepted Answer · answered Mar 18 '16 at 07:10

3

You may use below query-

SELECT * FROM estate_ad_listing ORDER BY eal_id DESC LIMIT 4,4;

Note: starting from 5th row and fetching next 4 rows.

answered Mar 18 '16 at 07:10

Zafar Malik

6,734
2
19
30

No.. it should be SELECT * FROM estate_ad_listing ORDER BY eal_id DESC LIMIT 4 OFFSET 4; – Shubham Jha Mar 21 '16 at 06:47
if you simply use limit 4,4 means you are saying that start from 5th row (0,1,2,3,4) and fetch next 4 rows. Are you not getting desired results by given query.. – Zafar Malik Mar 21 '16 at 06:49
means first parameter is offset and 2nd parameter is row count. – Zafar Malik Mar 21 '16 at 06:55

Counting TOP 4 rows from SQL after the first TOP 4 rows

1 Answers1