Subscribe: Comments on: keep dense_rank with multiple column
http://laurentschneider.com/wordpress/2007/08/keep-dense_rank-with-multiple-column.html/feed/
Added By: Feedage Forager Feedage Grade B rated
Language: English
Tags:
dense rank  dense  deptno  firstname  hiredate rowid  hiredate  lastname  max  order hiredate  order  rank order  rank  rowid  t group deptno 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: Comments on: keep dense_rank with multiple column

Comments on: keep dense_rank with multiple column



Oracle Certified Master



Last Build Date: Wed, 21 Feb 2018 07:37:54 +0000

 



By: DJ

Fri, 17 Aug 2007 14:34:47 +0000

Fair enough, but t is a table in your demo.



By: Laurent Schneider

Fri, 17 Aug 2007 13:27:03 +0000

well, sometimes yes, but not always, it may fail if t is a view



By: DJ

Fri, 17 Aug 2007 12:19:45 +0000

How about using rowid? select deptno, max(firstname) keep (dense_rank last order by hiredate,rowid) firstname, max(lastname) keep (dense_rank last order by hiredate,rowid) lastname, max(hiredate) hiredate from t group by deptno;