question about SQLite

[Digisoul]

Hello There,

I want to know that if i have 1000 records in SQLite DB, how can retrieve the data from the last Row ?

Thanks in Advance.

[JRowe]

You can nest queries:

select * from Table  having rowid (select max(rowid) from Table)

Replace Table with your table.

[Digisoul]

You can nest queries:

select * from Table  having rowid (select max(rowid) from Table)

Replace Table with your table.

Thank you very much JRowe.

[Digisoul]

Its give me this error ?

!   SQLite.au3 Error
--> Function: _SQLite_Query
--> Query:    select id from Area having rowid (select max(rowid) from Area);
--> Error:    near "select": syntax error

[Yoriz]

Try this

select * from Table where rowid in (select max(rowid) from Table)

Again replace Table with your table.

[Digisoul]

Try this

select * from Table where rowid in (select max(rowid) from Table)

Again replace Table with your table.

Not worked,

but this worked

"SELECT * FROM Table WHERE ROWID = ( SELECT MAX(ROWID) FROM Table) ;"

[Yoriz]

select * from Table where rowid in (select max(rowid) from Table)

works just fine, both ways work.

#include <SQLite.au3>
#include <SQLite.dll.au3>
Local $aRow
_SQLite_Startup ()
ConsoleWrite("_SQLite_LibVersion=" &_SQLite_LibVersion() & @CRLF)
_SQLite_Open () ; open :memory: Database
_SQLite_Exec(-1,"CREATE TEMP TABLE settings (key,value);")
_SQLite_Exec(-1,"INSERT INTO settings (key,value) VALUES ('1','setting one');")
_SQLite_Exec(-1,"INSERT INTO settings (key,value) VALUES ('2','setting two');")
_SQLite_Exec(-1,"INSERT INTO settings (key,value) VALUES ('3','setting Three');")
_SQLite_Exec(-1,"INSERT INTO settings (key,value) VALUES ('4','setting Four');")
_SQLite_QuerySingleRow(-1,"SELECT value FROM settings where rowid in (select max(rowid) from settings);",$aRow) ; Select single row and single field !
ConsoleWrite("SELECT value FROM settings where rowid in (select max(rowid) from settings); returns = " & $aRow[0] & @CR)
_SQLite_QuerySingleRow(-1,"SELECT value FROM settings WHERE ROWID = ( SELECT MAX(ROWID) FROM settings);",$aRow) ; Select single row and single field !
ConsoleWrite("SELECT value FROM settings WHERE ROWID = ( SELECT MAX(ROWID) FROM settings); returns = " & $aRow[0] & @CR)
_SQLite_Close ()
_SQLite_Shutdown ()
;Console output _SQLite_LibVersion=3.6.22
;Console output SELECT value FROM settings where rowid in (select max(rowid) from settings); returns = setting Four
;Console output SELECT value FROM settings WHERE ROWID = ( SELECT MAX(ROWID) FROM settings); returns = setting Four