Bikash Kumar Ray
SQL and ASP.net Related Practical Problems
Friday, September 18, 2009
Use of Case when Statement with multiple condition
SELECT distinct city,
(CASE city
WHEN 'Delhi' THEN '11'
WHEN 'chennai' THEN '22'
ELSE '33'
END) as STDCode
from area
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment