Results 1 to 2 of 2

Thread: Oracle

  1. #1

    Thread Starter
    New Member shashi101's Avatar
    Join Date
    May 2018


    Does GROUP BY Clause in Oracle gives Distinct values

  2. #2
    .NUT jmcilhinney's Avatar
    Join Date
    May 2005
    Sydney, Australia

    Re: Oracle

    Your question is far too vague. "gives Distinct values" is not a well-defined expression. the answer could be yes or no, depending what you actually mean. Please explain what you're trying to achieve, how you're trying to achieve it and what actually happens when you try.

    GROUP BY will generate one record per distinct set of values from the columns you group by and aggregated values for the other columns. If that's what you mean by "gives Distinct values" then yes, it does, otherwise it doesn't.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts


Click Here to Expand Forum to Full Width