-1

I have this code:

select DOLFUT from [DATABASE $]

How do I get it to get data from the 2nd line? (skip only the first line of data and collect all the rest)

Abdellah Ramadan
  • 367
  • 4
  • 15
Jessé Felício
  • 21
  • 1
  • 4
  • It looks like this question has been asked already: https://stackoverflow.com/questions/15032803/select-all-rows-except-top-row/15032884 – axme100 Feb 16 '20 at 06:25
  • how are you defining "first one"? you arent even ordering by anything – braX Feb 16 '20 at 06:39

3 Answers3

2

You can use LIMIT to skip any number of row you want. Something like

SELECT * FROM table
LIMIT 1 OFFSET 10

SELECT * FROM tbl LIMIT 5,10;  # Retrieve rows 6-15

To retrieve all rows from a certain offset up to the end of the result set, you can use some large number for the second parameter. This statement retrieves all rows from the 96th row to the last:

SELECT * FROM tbl LIMIT 95,18446744073709551615;

With one argument, the value specifies the number of rows to return from the beginning of the result set:

SELECT * FROM tbl LIMIT 5;     # Retrieve first 5 rows

MySql docs

Abdellah Ramadan
  • 367
  • 4
  • 15
  • 1
    `LIMIT` isn't available in MS Access - since the OP has marked this answer as the solution, perhaps this question is tagged incorrectly. – Lee Mac Feb 16 '20 at 13:32
0

In Access, which you seem to use, you can use:

Select DOLFUT 
From [DATABASE $] 
Where DOLFUT Not In
    (Select Top 1 T.DOLFUT 
    From [DATABASE $] As T 
    Order By 1)
Gustav
  • 53,498
  • 7
  • 29
  • 55
0

Data in tables have no inherent order.

To get data from the 2nd line

, you have to set up some sort sequence and then bypass the first record of the set - as Gustav has shown.

Orange
  • 73
  • 1
  • 1
  • 7