Re: [sqlite] Best way to get rowID of SELECT DISTINCT

[Denis Sbragion]

Hello Marco,

On Mon, February 20, 2006 09:56, Marco Bambini wrote:
> I have also tried this:
> CREATE VIEW v1 AS SELECT DISTINCT Artist FROM trax;
> SELECT rowid FROM v1

may be:

CREATE VIEW v1 AS SELECT Artist, min(rowid) as firstid FROM trax GROUP BY 
Artist;

This view will provide you the first rowid for any Artist in the trax view.

Bye,

-- 
        Denis Sbragion
        InfoTecna
        Tel: +39 0362 805396, Fax: +39 0362 805404
        URL: http://www.infotecna.it