Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref

Author Message

New User

Joined: 12 Apr 2007
Posts: 7
Location: bangalore

 Posted: Mon Apr 16, 2007 12:28 pm    Post subject: What is the difference b/w DISTINCT and GROUP BY What is the difference b/w DISTINCT and GROUP BY? can any one explain breifly..

ragganga

New User

Joined: 22 Jan 2007
Posts: 18
Location: bangalore

 Posted: Mon Apr 16, 2007 1:40 pm    Post subject: Hi Bhaskar, These question you can easily get better ans, when you search in 'Manuals' or any web site. DISTINCT - it will eliminates duplicate value when you define in Select statement. http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPJ11/1.1.3.4?DT=20040923112201 GROUP BY - find it in below link http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPJ11/1.1.6?DT=20040923112201 Regards Raghu
mkk157

Active User

Joined: 17 May 2006
Posts: 310

 Posted: Mon Apr 16, 2007 2:08 pm    Post subject: Hi Hi ragganga, The detailed information for both DISTINCT AND GROUPBY are ok. But How can we list out the differences in a simple manner instead of taking an example. I think this is what Bhaskar is looking for.
 All times are GMT + 6 Hours
 Page 1 of 1

Search our Forum:

 Topic Author Forum Replies Posted Similar Topics Difference between EQUAL and EQUAL TO... jithinraghavan COBOL Programming 3 Thu Apr 19, 2018 2:22 am Group changes and numbering the groups Auryn DB2 2 Tue Mar 20, 2018 7:12 pm How to group and sum the decimal value sakrat DFSORT/ICETOOL 2 Tue Mar 06, 2018 9:13 pm ISMF Difference between volume count ... upendrasri IBM Tools 2 Tue Dec 05, 2017 12:40 pm Increment number for every group of r... srajendran2 DFSORT/ICETOOL 7 Thu Nov 09, 2017 10:31 pm

 © 2003-2017 IBM MAINFRAME Software Support Division
 Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us