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
"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
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
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
> 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
-
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
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
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
8 matches
Mail list logo