IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

What is the difference b/w DISTINCT and GROUP BY


IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
bhaskar80

New User


Joined: 12 Apr 2007
Posts: 7
Location: bangalore

PostPosted: Mon Apr 16, 2007 12:28 pm
Reply with quote

What is the difference b/w DISTINCT and GROUP BY? can any one explain breifly..
Back to top
View user's profile Send private message
ragganga

New User


Joined: 22 Jan 2007
Posts: 18
Location: bangalore

PostPosted: Mon Apr 16, 2007 1:40 pm
Reply with quote

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.

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPJ11/1.1.3.4?DT=20040923112201

GROUP BY - find it in below link

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPJ11/1.1.6?DT=20040923112201

Regards
Raghu
Back to top
View user's profile Send private message
mkk157

Active User


Joined: 17 May 2006
Posts: 310

PostPosted: Mon Apr 16, 2007 2:08 pm
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Mainframe Interview Questions

 


Similar Topics
Topic Forum Replies
No new posts Timestamp difference and its average ... DB2 11
No new posts Difference when accessing dataset in ... JCL & VSAM 7
No new posts Compare latest 2 rows of a table usin... DB2 1
No new posts Problem with IFTHEN=(WHEN=GROUP,BEGIN... DFSORT/ICETOOL 5
No new posts Splitting group records based on deta... DFSORT/ICETOOL 8
Search our Forums:

Back to Top