Home / Questions / 534358
Accepted
EMCode
Asked: 2022-07-16 17:25:25 +0800 CST 2022-07-16 17:25:25 +0800 CST

SELECT query that omits the first result

  • 772

With the following SQL statement

SELECT * FROM table ORDER BY fecha DESC

I get these results:

Title Date
Item A 2022-02-16
Item B 2022-01-15
Item C 2022-01-30

What I need is that this query omits the first result ( Item A ), but the operator does not work for me, LIKEnor does any event with the date, this is because the results could be any, and the ORDER BYcan change dynamically (it could be ASCor DESC) .

That's why I only need to skip the first result or row of that statement SELECT, and display the results starting from the second row, like so:

Title Date
Item B 2022-01-15
Item C 2022-01-30

Is this possible? I was reviewing the function MODbut its use is not very clear to me.

mysql

2 Answers

  1. Best Answer

    Try LIMIT...

    SELECT * FROM table ORDER BY fecha DESC LIMIT 1,1000

    that will return 1000 records starting at the second record (depends on ORDER BY or the index used)

    • 3

  2. SQL-SERVER

    SELECT * FROM table ORDER BY fecha DESC
OFFSET 1 ROWS // omite la primera fila
FETCH NEXT 1000 ROWS ONLY; // te traera 1000 filas despues de la fila omitida
    • 2