[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
On Tue, Mar 29, 2011 at 8:24 PM, Tom Brough <tombrough@xxxxxxxxxxxxxxxx> wrote: > I ran a few query's today to try and answer the above question, I thought I > might share the results. > >>select count(*) from staff where department = 'IT' and role = 'manager' and >> skills = 'technical' and background = 'open source'; > > no rows selected > > Ok well that was obvious .... lets try something else .... > >>select count(*) from staff where department = 'IT' and role = 'manager' and >> skills = 'technical' and background = 'proprietary'; > > no rows selected > > hmm surprising ... ok maybe its something to do with skills ? > >>select count(*) from staff where department = 'IT' and role = 'manager' and >> skills = 'none' and background = 'proprietary'; > > count(*) > ----------- > 200 > > wow that's a bit on the high side ..... > > how managers do we have ? > >>select count(*) from staff where department = 'IT' and role = 'manager' and >> skills = 'none'; > > count(*) > ----------- > 200 > > Ok surely I missed something ? > >>select count(*) from staff where department = 'IT' and role = 'manager' > > count(*) > ----------- > 200 > > Ok so I have a large number of managers all with proprietary backgrounds and > no skills .... So must be a huge IT department with all those managers.... > >>select count(*) from staff where department = 'IT'; > > count(*) > ----------- > 201 > > That cant be right surely ? > >>select name from staff where department = 'IT' and role <> 'manager'; > > name > ------------ > you > > Figures ..... hahahahah! brilliant lol. You had a bad day Tom? or just a random bit of sql you wanted to share lol. roly :-) -- The Mailing List for the Devon & Cornwall LUG http://mailman.dclug.org.uk/listinfo/list FAQ: http://www.dcglug.org.uk/listfaq