IT Employment·20,064 discussions

COUNT(*) OVER ()

Locked

Can someone please explain the count(*) OVER () sql function in an Oracle context. I would like to know what it does, when to use it, how it is beneficial. Or at least point me somewhere I can learn more about it.

Thanks

Topic

Clarifications

In reply to COUNT(*) OVER ()

Clarifications

I don’t understand this very well myself

In reply to COUNT(*) OVER ()

but here is a reference:
http://orafaq.com/node/55

[Author]

Replies