SQL Interview Questions - rohith-nallam/Bigdata GitHub Wiki

How do you delete duplicates using row_number()

select *,row_number() over(partition by all columns) from table?

what is the difference between rank and dense_rank()?

How to add filter operation on right tables when we do left join?

https://stackoverflow.com/questions/24076454/left-join-with-where-clause-for-right-table-must-return-null-from-right-orac

what is ntile function in oracle?

It is an analytical function which helps to create equl number of buckets