Re[2]: [sqlite] query to get count of fields with different values

2005-11-20 Thread Wilfried Mestdagh
Hi Guillaume, > select distinct name from table_name; This does exacly what I want ! Thx :) --- Rgds, Wilfried http://www.mestdagh.biz

Re: [sqlite] query to get count of fields with different values

2005-11-20 Thread Guillaume MAISON
Wilfried Mestdagh a écrit : Hello, I'm not sure if subject make sence (English is not my mothers tongue), I try to explain: I have a table and a field called 'Name' can have a lot of the same but also different values. I want (if exists of course) to do a query where I only get as result the

[sqlite] query to get count of fields with different values

2005-11-20 Thread Wilfried Mestdagh
Hello, I'm not sure if subject make sence (English is not my mothers tongue), I try to explain: I have a table and a field called 'Name' can have a lot of the same but also different values. I want (if exists of course) to do a query where I only get as result the exclusive names. I give example