Conditional Statements in PL/SQL are same as conditional statements available in java, c++, c or any other language. PL/SQL allows processing of data using the following conditional statements:
* IF
* CASE
7/25/12
7/6/12
GROUP BY vs DISTINCT in SQL
This question has to come my mind many times and also I have been asked the same question many time. That what should be used GROUP BY or DISTINCT, as both perform the same thing.
So, after researching and using both statements and checking the performance using some scripts from here and there, I have come to the conclusion that GROUP BY performs much better then DISTINCT.
Now before, we move on to more discussion, lets first understand what does actually both do.