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
Posted by Unknown at 12:13 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

Unknown
View my complete profile

Blog Details

  • ►  2013 (6)
    • ►  November (1)
    • ►  June (1)
    • ►  February (4)
  • ►  2012 (4)
    • ►  October (1)
    • ►  May (1)
    • ►  February (1)
    • ►  January (1)
  • ►  2011 (9)
    • ►  December (1)
    • ►  November (1)
    • ►  September (1)
    • ►  July (1)
    • ►  May (1)
    • ►  April (4)
  • ►  2010 (13)
    • ►  September (1)
    • ►  August (5)
    • ►  July (2)
    • ►  May (1)
    • ►  February (4)
  • ▼  2009 (38)
    • ►  December (5)
    • ►  November (4)
    • ►  October (2)
    • ▼  September (3)
      • SQL Data Caching
      • using System.Web.Caching;using System.Data.SqlClie...
      • Use of Case when Statement with multiple condition
    • ►  August (4)
    • ►  July (5)
    • ►  June (6)
    • ►  May (3)
    • ►  April (6)

Worked Websites

  • eDMS
  • Plyreporter
  • Tour and Travel Website
  • Tradeget
Ethereal theme. Powered by Blogger.