Jump to content

SQL for all but the FIRST row


dannybrazil

Recommended Posts

Hello

 

I have a table of many entries , and I need to retrieve specific one's ex:

 

"SELECT  * FROM  pairs WHERE  pair='eurusd' AND graph_type='mn' ORDER BY id DESC"

 

now lets say he found 5 entries....(ID 1..2..3..4..5)

 

I need them in this order :

5

4

3

2

1

How can i add a LIMIT the he would NOT print the 5th ID ? (the last one uploaded into the database)

 

Danny

 

 

Link to comment
https://forums.phpfreaks.com/topic/189176-sql-for-all-but-the-first-row/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.