We will begin with how aggregate function is different from Analytic Function. We will start with some example.
Query 1 : Select branch_id, count(*) Branch_Count from emp where branch_id in (10,30);
Output :
branch_id Branch_Count
10 5
20 [...]
Archive for the ‘Technical’ Category
Example : Analytic Function
Posted in Technical on November 24, 2008 | Leave a Comment »
Oracle : Analytic Function
Posted in Oracle, Technical on November 24, 2008 | Leave a Comment »
Basically this post is meant for PL/SQL coders who might not be using analytic function (like me) due to very complex syntax. Personally i found analytic function to be very useful and recently i used it in my project since there was requirement which can be fulfilled only Analytic Function. So i can say my [...]
ICloud
Posted in Technical on September 27, 2008 | Leave a Comment »
Today i really come with something really good in WEBOS i.e. ICloud. I registered the user name but it seems it will take some time to activate my username. But the Screen Shots looks really very promising. There are many WEBOS presents but it really lacks the good feel of OS. I am really looking [...]
Scour Search
Posted in Technical on August 10, 2008 | 2 Comments »
A one more competitor in the search engine war. After Google, Yahoo, Microsoft Live, Altavista, Dogpile…and many more, we have one more new competitor who entered in this war i.e. Scour.
As such i didnt find nething interesting in this search engine. Its features is it combines all the result of google, yahoo and live which [...]
Cool Webmail Service…
Posted in Technical on August 6, 2008 | 1 Comment »
Today i came up vth really Good site zenbe. Its a free webmail service which is not a new thing. But the best part is u can access all your mails from yahoo, Gmail and Hotmail in this webmail, but for this u shud have the Pop3 Access. Gmail provides Pop3 service free but other [...]
