Ok, I have a solution sort of.
We installed sqllite .94 in assemble of the machine. Using the command prompt
we manually copied the interop dll into the same assemble directory. If you
don't, we would get the missing interop dll message.
Then we went into the exe and dll and changed the tar
Hello,
FYI: First a big thanks to the wonder of SQLite.
May I introduce football.db - a free open public domain football
data project that offers its datasets as SQLite files, thus, the
project name football.db (it's the actual single-all-in-one SQLite
file/database that inspired it).
Y
Hi!
SQL Maestro Group announces the release of SQLite Maestro 15.1, a complete
Windows GUI solution for SQLite database management. The new version is
immediately available at
http://www.sqlmaestro.com/products/sqlite/maestro/
Top new features
=
1. Support for user authentica
A correlated subquery:
select *
from t
where (select count(*)
from t as b
where b.data1 = t.data1) >= 3;
or with a subselected set of valid rows:
select *
from t
where data1 in (select data1
from t as b
group by data1
h
Hello,
thanks a lot. Works like a charm!
I should really do more sql.
Thanks,
Hajo
Am 13.01.2015 um 09:03 schrieb Hick Gunter:
Step 1: count the occurrences:
SELECT data1,count() AS count FROM table GROUP BY data1;
Step 2: get the rows with a count above the limit
SELECT data1,count() AS
Step 1: count the occurrences:
SELECT data1,count() AS count FROM table GROUP BY data1;
Step 2: get the rows with a count above the limit
SELECT data1,count() AS count FROM table GROUP BY data1 HAVING count >= 3;
Step 3: get the keys from the rows
SELECT data1 FROM (SELECT data1,count() AS cou
6 matches
Mail list logo
