Tag Archives: Distinct

#SQLSERVERLearning : Order By Learning.

Most of folks feel , both(Oracle-SQLServer) are traditional RDBMS database and should or need to work some what “SIMILAR”. But, But when we actually start working on core with queries, development and tuning.We identified a lot of difference between any … Continue reading

Rate this:

Posted in SQL Server Learning | Tagged , , , , , | Leave a comment

Aggregate Function , Distinct and NULL Values in Oracle.

While working on SQL Server with queries having aggregation got a warning message. “Warning: Null value is eliminated by an aggregate or other SET operation.” So thought let write up something on Aggregation and NULL Values for Tradition RDBMS for … Continue reading

Rate this:

Posted in Oracle Internal | Tagged , , , | Leave a comment

Does Distinct operation in oracle return sort data?

When started my learning with Oracle on Pre 10.2 version, I personally use to rely on distinct to do ascending sorting.At that point was not aware of internal concepts, implicit sorting and distinct correlate as per an underscore/internal parameter (post … Continue reading

Rate this:

Posted in Oracle Internal | Tagged , , , , , , | 3 Comments