Topic profile page for Analytic functions.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Analytic functions.
Topic "Analytic functions" was discussed 144 times on 15 sites in last 3 months
Started 2 days, 23 hours ago (2010-03-12 00:10:00)
by Massimo Ruocchio
Use string aggregation: select col_id, sn_code, max(seq_no), rtrim(extract(xmlagg(xmlelement( "a" ,value|| ',' )), '//text()' ), ',' ) values from yourtable group by col_id, sn_code Max http://oracleitalia.wordpress.com
Started 1 week, 2 days ago (2010-03-05 12:48:00)
by jimmyb
Here is the table structure: table_1 user_seq number pos_id number end_date date start_date date Data looks like this: USER_SEQ POS_ID START_DATE END_DATE 1 5 02-APR-2006 15-MAR-2008 1 10 16-MAR-2008 1 20 14-FEB-2010 2 55 31-JAN-1999...
Started 1 week, 2 days ago (2010-03-05 14:40:00)
by Buga
Hi, Any expected output with more examples would have helped. From what i could understand. For a particular user if the end_date is not specified then the end_date should be the max start_date's previous day. If that is what you need, here is the query with data as (select 1 USER_SEQ , 5 POS_ID , to_date( '02-APR-2006' , 'DD-MON-YYYY' ) START_DATE ,...
Started 1 month ago (2010-02-12 04:54:00)
by chakra
Hi, I would like to use analytic func to pick up max value of a column without using group by functions? SQL> select * from t order by 2 desc; C1 C2 ---------- Steve 3 James 2 James 1 Pete 1 SQL> -- Selecting Max(c2) SQL> select * from ( 2 select c1,c2 from t 3...
Started 1 month, 2 weeks ago (2010-01-27 21:42:00)
by eskimo343
Let be a sequence of analytic functions on a domain that converges normally to . Suppose that attains each value at most times (counting multiplicity) in . Show that either is constant, or attains each value at most times in . We have covered Hurwitz's Theorem and a theorem that says: Suppose is a sequence of univalent functions on a domain that converges normally on ...
Started 3 weeks, 3 days ago (2010-02-18 09:57:00)
by beilstwh
Read up on the LEAD and LAG functions for select. See the following link. ORACLE-BASE - LAG and LEAD Analytic Functions or search on google using oracle load lag