over partition

Hi
Can any one provide me the material or documents of how to use "over partition by" clause in sql.I am new to this syntax and have least idea about it.


Thanks
Emv