Friday, January 28, 2011

How many partions in given SQL ?

Partition by CASE_N
( empSalary < 10000,
empSalary < 20000,
empSalary < 300000
empSalary < 4000000,
NO CASE OR UNKNOWN)
)

Ans: 5 Partitions

No comments:

Post a Comment