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: 3724
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: Tue Dec 06 04:38:15 CST 2016

Total time taken to generate the page: 0.15480 seconds