Howdy,
"Jay Macaulay" <[EMAIL PROTECTED]>
23/10/2003 05:55 AM
To: <[EMAIL PROTECTED]>
cc:
Subject:[sqlite] Problem with LIMIT and transactions? Or is it just me
> I am running into a real odd problem that I hope someone can explain. I
> have a
Reply at the bottom.
LucaBala wrote:
I've a table (COLOURS) with 8 rows (like below), columns CODE (integer
primary key) and NAME:
100 BLACK
103 BLUE
104 GREEN
109 GRAY
111 LIGHT GREEN
112 LIGHT BLUE
120 LIGHT RED
121 RED
When I do this command...
SELECT * FROM colours WHERE code >= 100
Hi,
I have noticed that it is hard to acheive the count (distinct a) command
in sqlite. However, I have tried the suggested work around by:
SELECT count(ticker) FROM (SELECT DISTINCT ticker FROM ListDetail WHERE TableName
LIKE "sixty%" AND Ticker <> ""
This is also giving an error, is there
3 matches
Mail list logo