Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. philb007

    group by - but flag if particular value exists

    Hi, I HAVE 3 fields, CUSTOMER_ID, COLOUR and price CUSTOMER_ID COLOUR price 1 RED 13 1 BLUE 23 2 YELLOW 4 2 BLUE 54 2 RED 35 ETC. I have a group by cutomer_id and want to return for that customer a flag to say if they chose a particular colour (say RED) I can do max(colour) as an aggregate...

Part and Inventory Search

Back
Top