MI-L SQL Query Question

[Ron Gutiw]

Listers:

Is there any way to select the first 3 records from each group in a query?
ie:  
  select * from street_table where ??????? group by address
results:
  address1  col1 col2 col3 1
  address1  col1 col2 col3 2
  address1  col1 col2 col3 3
  address2  col1 col2 col3 1
  address2  col1 col2 col3 2
  address2  col1 col2 col3 3
  . . . 
  addressx  col1 col2 col3 1
  addressx  col1 col2 col3 2
  addressx  col1 col2 col3 3

Thanks
Ron


 
 
 
 

 

---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]