05-13-2014 08:58 AM
I would like to ask you how to get from "have" to "wanna" base.
I know the logic, but cannot really figure out the code...
I should assign e.g. item for every observation and delete each company which has item number <4
Thank you in advance!
05-13-2014 09:11 AM
Well, few ways to do it in SQL, heres one:
create table want as
,count(1) as tmp
group by company
05-13-2014 09:16 AM
input Company $ Year;
select * from have group by company having count(*)=4;
Need further help from the community? Please ask a new question.