I am just starting with DB2 and I need this pretty urgent.
My Db2 table has following feilds:
Can any one please suggest an SQL to do the following:
1. I need to pick up the states starting with SL & PF.
2. The results should order by policy
3. TOTAL NUMBER OF STATES THAT BEGIN BY sl%,ov% and of% or f%, by policy