How would you write this sql statement

Assignment Help Computer Engineering

Reference no: EM133258475

Question: You are inserting values into a field (CODE) based on a set of conditions from another field (DESCRIPTION). If the value in DESCRIPTION equals H then the value inserted into the CODE field should be 1. If the value in DESCRIPTION equals O then the value inserted into the CODE field should be 2. If there is any other value in the DESCRIPTION field, then the CODE field should be set to NULL. How would you write this SQL statement?

Reference no: EM133258475

Questions Cloud

Explain arizona definition of an english learner : ESL-436N Methods of Structured English Immersion for Early Childhood Education - Analyzing Arizona Language Development Approach, Grand Canyon University

How could you make the execution more deterministic : CISC 530 Harrisburg University of Science and Technology How could you make the execution more deterministic so that only one set of values is possible

Write a delete statement to delete the rows you added : CHEM 624 Yale University Write a DELETE statement to delete the rows you added to the CATEGORY table in question 2. The command should use the CategoryName

Design a circuit that accepts as input a 3-bit binary number : CS 270 Rockland Community College, Design a circuit that accepts as input a 3-bit binary number and determines if it is even (i.e., outputs a one of it is even

How would you write this sql statement : CHEM 221A Yale University If the value in DESCRIPTION equals O then the value inserted into the CODE field should be 2. If there is any other value

How and why did those views change as time passed : How and why did those views change as time passed? Why are the atrocities in the Congo not known more widely around the world

Write a monitor for the tunnel problem : University Of Chicago Write a monitor for the tunnel problem that guarantees that no direction of travel can be blocked indefinitely and thus prevents

Review the four elements of the management process : Review the 4 elements of the management process. Which of the 4 elements of management would you be best at performing? Why

How to pass up to 4 parameters to a function : ENG 1101 Tarrant County College, ow to pass up to 4 parameters to a function and how a result is returned from a function. As a simple example

User Account

All Pages