Home » SQL & PL/SQL » SQL & PL/SQL » meaning of "partition by null" in analytic functions (oracle 10g, aix 5.3)
meaning of "partition by null" in analytic functions [message #593513] Sun, 18 August 2013 00:12 Go to next message
kang
Messages: 89
Registered: November 2007
Member
What's the meaning of "partition by null" in analytic functions
like 
select emp_no, dept_nm, count(*) over(partition by null) cnt 
  from some_table

is it right there is no partition?

Report message to a moderator

Re: meaning of "partition by null" in analytic functions [message #593514 is a reply to message #593513] Sun, 18 August 2013 00:48 Go to previous message
Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
It means the one that use this does not understand the analytical function.
Yes, there is no partitions.

It is different when you use "ORDER BY null", it is used when ORDER BY clause is mandatory (like in ROW_NUMBER) but you don't care about the order of the rows.

Regards
Michel

Report message to a moderator

Previous Topic: Help in oracle query
Next Topic: doubt in writing query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 01 00:10:40 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.