Click here to Skip to main content
14,237,438 members
   

Database

 
QuestionSQLite how to delete rows in a table (C++) Pin
steve_94966138-Feb-19 5:08
professionalsteve_94966138-Feb-19 5:08 
AnswerRe: SQLite how to delete rows in a table (C++) Pin
k50548-Feb-19 7:21
memberk50548-Feb-19 7:21 
GeneralRe: SQLite how to delete rows in a table (C++) Pin
steve_949661310-Feb-19 21:30
professionalsteve_949661310-Feb-19 21:30 
GeneralRe: SQLite how to delete rows in a table (C++) Pin
k505413-Feb-19 7:14
memberk505413-Feb-19 7:14 
GeneralRe: SQLite how to delete rows in a table (C++) Pin
steve_949661320-Feb-19 20:55
professionalsteve_949661320-Feb-19 20:55 
GeneralRe: SQLite how to delete rows in a table (C++) Pin
k505421-Feb-19 7:15
memberk505421-Feb-19 7:15 
GeneralRe: SQLite how to delete rows in a table (C++) Pin
steve_949661325-Feb-19 4:25
professionalsteve_949661325-Feb-19 4:25 
AnswerRe: SQLite how to delete rows in a table (C++) Pin
Mycroft Holmes8-Feb-19 12:50
memberMycroft Holmes8-Feb-19 12:50 
If "DataOra" or "Evento" are not your line numbering system then you have a problem.

Assuming there is some sort of sequence in your data, date or number you could select the top 50000, get the sequence value and then delete anything less than the selected sequence. I would test this on a copy of the database Big Grin | :-D

select - How to get Top 5 records in SqLite? - Stack Overflow[^] add an orderby your sequence field and you get the values for your where condition.
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

GeneralRe: SQLite how to delete rows in a table (C++) Pin
steve_949661310-Feb-19 21:56
professionalsteve_949661310-Feb-19 21:56 
GeneralRe: SQLite how to delete rows in a table (C++) Pin
Mycroft Holmes11-Feb-19 10:53
memberMycroft Holmes11-Feb-19 10:53 
AnswerRe: SQLite how to delete rows in a table (C++) Pin
Richard MacCutchan8-Feb-19 22:44
protectorRichard MacCutchan8-Feb-19 22:44 
GeneralRe: SQLite how to delete rows in a table (C++) Pin
steve_949661310-Feb-19 21:58
professionalsteve_949661310-Feb-19 21:58 
Questionfinding periods Pin
joost.versteegen8-Feb-19 4:22
memberjoost.versteegen8-Feb-19 4:22 
AnswerRe: finding periods Pin
joost.versteegen9-Feb-19 10:40
memberjoost.versteegen9-Feb-19 10:40 
Questionupdate temp table with results from sub query (actually it is a function) Pin
joost.versteegen7-Feb-19 3:32
memberjoost.versteegen7-Feb-19 3:32 
AnswerRe: update temp table with results from sub query (actually it is a function) Pin
ZurdoDev7-Feb-19 4:36
professionalZurdoDev7-Feb-19 4:36 
GeneralRe: update temp table with results from sub query (actually it is a function) Pin
joost.versteegen7-Feb-19 4:45
memberjoost.versteegen7-Feb-19 4:45 
AnswerRe: update temp table with results from sub query (actually it is a function) Pin
Richard Deeming7-Feb-19 8:34
mveRichard Deeming7-Feb-19 8:34 
GeneralRe: update temp table with results from sub query (actually it is a function) Pin
joost.versteegen7-Feb-19 11:20
memberjoost.versteegen7-Feb-19 11:20 
GeneralRe: update temp table with results from sub query (actually it is a function) Pin
joost.versteegen7-Feb-19 20:33
memberjoost.versteegen7-Feb-19 20:33 
QuestionTables left and right Pin
Member 141362635-Feb-19 5:21
memberMember 141362635-Feb-19 5:21 
AnswerRe: Tables left and right Pin
Richard MacCutchan5-Feb-19 6:10
protectorRichard MacCutchan5-Feb-19 6:10 
AnswerRe: Tables left and right Pin
ZurdoDev7-Feb-19 4:41
professionalZurdoDev7-Feb-19 4:41 
QuestionUsing JSON functions with Always Encrypted data in SSMS Pin
Hypermommy4-Feb-19 6:06
memberHypermommy4-Feb-19 6:06 
AnswerRe: Using JSON functions with Always Encrypted data in SSMS Pin
Richard Deeming4-Feb-19 9:20
mveRichard Deeming4-Feb-19 9:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.