Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
Distinct Clause
This is a discussion on Distinct Clause within the Oracle forums, part of the Databases category; Hi, Is there any difference for Distinct clause from 9i to 10g while retreving data from table? Regards, vijayakumar...
|
|||||||
| Oracle Oracle 9i & Oracle 10g Knowledge Base Learn and Share Oracle Technology related articles, white papers, tutorials / study materials, example codes, FAQ's, Tips and Tricks. |
 |
| LinkBack | Thread Tools | Display Modes |
09-04-2008
|
|||
|
|||
|
Distinct Clause
Hi,
Is there any difference for Distinct clause from 9i to 10g while retreving data from table? Regards, vijayakumar 
|
| Sponsored Links |
|
09-04-2008
|
|||
|
|||
|
Re: Distinct Clause
The DISTINCT and "GROUP BY" are two clauses that inherently force the sorting of data set in case of Oracle 9i.
The SQL optimizer in 10g does not sort the data in order to remove duplicates.
|
|
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| difference bet unique and distinct | smitai | Oracle Certification | 4 | 3 Weeks Ago 08:35 AM |
| difference between unique and distinct | arpitace | Oracle | 2 | 08-12-2008 08:17 AM |
| Distinct keyword in Oracle SQL | ily_saravanan | SQL | 1 | 03-29-2008 12:45 AM |
| Load Distinct and Duplicate values to different targets | tanya123 | Data Warehousing | 1 | 02-25-2008 09:06 PM |
| Alternative for SELECT DISTINCT to query 2 million records | Geek_Guest | SQL | 1 | 08-06-2007 09:29 AM |
All times are GMT -4. The time now is 03:10 PM.
