Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Query Areas

Discussion in 'Information Technology' started by kevcar40, Jul 28, 2006.

  1. kevcar40

    Expand Collapse

    i have a query that returns the top 5 areas giving a problem
    Area 1
    Area 2
    Area 3
    Area 4
    Area 5

    my table has the fields area, reason and component
    there are as many as 20 areas
    my first query counts the areas returning area and quantiny

    what i want to do is return the top 3 faults against each area

    ie area 1 fault 1
    area 1 fault 2
    area 1 fault 3
    any idaes

    thanks kevin
  2. Loading...

    Similar Threads Forum Date
    Query About Jhatka Meat By Shooting In Head Sikh Sikhi Sikhism Aug 26, 2011
    Who Is A Sikh? A Non Sikh Friend's Query! Sikh Sikhi Sikhism Apr 30, 2010
    General Query Hard Talk Sep 4, 2008
    Power Of Pauri's In Japji Sahib Query Sikh Sikhi Sikhism Aug 17, 2006
    Sikhism A Query Book Reviews & Editorials Aug 2, 2005

Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page