I am a oracle database developer. Today I first tried "OpenOffice Base". I have a ods-spreadsheet with a list of persons (first name, last name , address, telephon number, email,...). I created a Base Database with my spreadsheet as existing database. Then I opened the SQL-Editor and tried following statement:
Code: Select all
select email, count(*) as quantity
from person
group by email
having count(*) > 1
For me it seems that "group by" doesn't work in "OpenOffice Base". The query
Code: Select all
select last_name
from person
group by last_name
Code: Select all
select last_name
from person
~Bernd