Home » SQL & PL/SQL » SQL & PL/SQL » Diff b/w distinct & group by clause
Diff b/w distinct & group by clause [message #207514] Tue, 05 December 2006 21:09 Go to next message
kanmani_karuppannan
Messages: 23
Registered: November 2006
Location: India
Junior Member

Hi All,

What is the difference between distinct and group by clause.

Please tell me.

Redards,
Kanmani.
Re: Diff b/w distinct & group by clause [message #207518 is a reply to message #207514] Tue, 05 December 2006 21:18 Go to previous message
rleishman
Messages: 3727
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Run these two queries and find out.
SELECT DISTINCT owner
FROM all_tables
GROUP BY owner, table_name

SELECT owner
FROM all_tables
GROUP BY owner, table_name


Ross Leishman
Previous Topic: Materialized View refreshed with invoker's schema
Next Topic: to check the datatype of argument passed inside procedure
Goto Forum:
  


Current Time: Thu May 25 11:15:41 CDT 2017

Total time taken to generate the page: 0.16460 seconds