PLSQL CASE query examples

–Case Query in Sql:

UPDATE [account]
SET balance =(CASE WHEN ((balance – 10.00) < 0) THEN 0 ELSE (balance – 10.00) END) WHERE id=1

SELECT productId,
‘status’ = CASE WHEN quantity > 0 THEN ‘in stock’ ELSE ‘out of stock’ END
FROM inventory

Advertisements

About Gokul Dahal, Nepal

Software Engineer, Freelancer, Design and Develop web applications,Software Developer Nepal, FreeLancer Nepal Contact : gokuldahal@gmail.com
This entry was posted in SQL and tagged , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s