[sqlite] What query should I use?

2008-11-20 Thread wojtek
Hi all, I have a problem with a query that I thought is easy. I have a database containing a following data: CREATE TABLE [Magazyn] ( [IdMagazyn] integer PRIMARY KEY AUTOINCREMENT , [IdMat] integer, [Partia] varchar (10), [Ilosc] integer, [DelK] integer DEFAULT 0, [Mdata] integer

Re: [sqlite] What query should I use?

2008-11-20 Thread Igor Tandetnik
"wojtek" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Then, I have the following data in this Table: > IdIdMat Partia Ilosc DelK > 1614577149001 > 5614577149001 > 6614577144801 > 7614760519000 > 8614

Re: [sqlite] What query should I use?

2008-11-20 Thread Simon Davies
2008/11/19 wojtek <[EMAIL PROTECTED]>: > Hiall, > I have a problem with a query that I thought is easy. I have a database > containing a following data: > CREATE TABLE [Magazyn] > ( >[IdMagazyn] integer PRIMARY KEY AUTOINCREMENT , >[IdMat] integer, >[Partia] varchar (10), >[Ilosc] i

[sqlite] What query should I use?

2008-11-20 Thread wojtek
Hiall, I have a problem with a query that I thought is easy. I have a database containing a following data: CREATE TABLE [Magazyn] ( [IdMagazyn] integer PRIMARY KEY AUTOINCREMENT , [IdMat] integer, [Partia] varchar (10), [Ilosc] integer, [DelK] integer DEFAULT 0, [Mdata] in

Re: [sqlite] What query should I use?

2007-04-05 Thread Hugh Gibson
> but of course there is an EXACT answer for my question - there are > selected only the rows when Text2 changes... How to get also always > the first row from original data set? Just UNION the result with a query that gets the first row from the table. Hugh -

Re: [sqlite] What query should I use?

2007-04-05 Thread woj
Hi Igor, Thanks for your reply, the query you have suggested works fine, but there is missing the first row, so the result look: IdText1 Text2 Text3 Text4 --- 31003 12 test04 test12 61005 11 test17 test67 71005

Re: [sqlite] What query should I use?

2007-04-04 Thread Gussimulator
try the DISTINCT keyword ? - Original Message - From: "erw2" <[EMAIL PROTECTED]> To: Sent: Wednesday, April 04, 2007 4:14 PM Subject: [sqlite] What query should I use? Hi, I have a table with a following data: IdText1 Text2

[sqlite] What query should I use?

2007-04-04 Thread erw2
Hi, I have a table with a following data: IdText1 Text2 Text3 Text4 --- 11001 11 test03 test13 21002 11 test01 test11 31003 12 test04 test12 41004 12 test02 test34 51004 12 test06