Re: [sqlite] How to get the original rows after 'group by'?

Hi, Without using sqlite, I can sort the table test ('sort' is from coreutils, sort on the 1st column then the 2nd column), then I use awk to parse the sorted file to get what I need. Should this approach be faster than the sqlite query (in terms of runtime, not in term of programming time)? On

Re: [sqlite] How to get the original rows after 'group by'?

you can use: select col1, col2 from test where col1 in (select col1 from test group by col1 having count(*)<=2); David --- On Thu, 8/26/10, Peng Yu wrote: > From: Peng Yu > Subject: [sqlite] How to get the original rows after 'group by'? > To: