interesting "group by" usage

I have a table that contains jobs done by different people at different times and I have a need to see a list of names with unique name entries. So I tried a

> select fname, lname from job_done group by fname, lname;

that works! ("not a group by expression" isn't it? ;-) -- indeed, when I tried the same thing through a web interface (via CGI <-> SQLPLUS) it complains "not a group by expression" Any thought why?

Or is there an option that allows return of unique entries? (I didn't seem to find one).

Zhiliang Received on Mon Mar 05 2001 - 17:55:27 CST