Re: extracting a sample of each condition

On Jul 25, 3:18 am, Akhilesh <toakkiya...@xxxxxxxxx> wrote:
try out this query:

select plan, type1, type2, type3 from table
where <<conditions>>
group by plan, type1, type2, type3

might help you out

How would that give me the the first Name and Amount for each group?

.

Relevant Pages

  • Re: extracting a sample of each condition
    ... select plan, type1, type2, type3 from table ...
    (comp.databases.oracle.misc)
  • Lookup and paste
    ... type1 old 123 ... type3 new 789 ... I need to match the two criteria ie type2 and old to get 456. ... Then match type2 and B in the same worksheet as well as yesterdays date ...
    (microsoft.public.excel.programming)
  • Re: Remove repeat section headers
    ... but I need to have a header for each and mess with the ...
    (microsoft.public.access.reports)
  • Re: Remove repeat section headers
    ... actually want it to group within the types but rather group the entire type1 ... but I need to have a header for each and mess with the ...
    (microsoft.public.access.reports)
  • Re: Remove repeat section headers
    ... but I need to have a header for each and mess with the ...
    (microsoft.public.access.reports)