SQL statement to pick up the states starting with SL & P

ap_mainframes · Posted: Thu Sep 11, 2008 8:34 pm

Hi,

I am just starting with DB2 and I need this pretty urgent.

My Db2 table has following feilds:
Policy
state

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

Thanks for all the help you can provide.

Jerine_Cao Xiaojie · New User Joined: 07 Sep 2008 Posts: 2 Location: Nanchang

hello,

select state from TableName where state = 'sl%' or state = 'pf%' order by policy desc

I wish it can do help for you.