how to use case expression? : Sql dba



how to use case expression? : Sql dba..

Answer / Ajay Kumar Chaudhary

The CASE expression in SQL is used for conditional evaluation of expressions. The basic syntax is: nnCASEn WHEN condition_1 THEN result_1n WHEN condition_2 THEN result_2n ...n ELSE else_resultnEND;

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What are the 3 types of behavioral triggers?

1 Answers  


what is the difference between a local and a global temporary table? : Sql dba

1 Answers  


how many sql dml commands are supported by 'mysql'? : Sql dba

1 Answers  


How packaged procedures and functions are called from the following?

2 Answers  


explain access control lists. : Sql dba

1 Answers  


what is variable in package specification

3 Answers  


what are the different tables present in mysql? : Sql dba

1 Answers  


Which command is used to delete a trigger?

1 Answers  


wht is the difference between sqlaserver2000 and 2005

1 Answers   ABC, IBM,


what is schema? : Sql dba

0 Answers  


Why we use sql profiler?

1 Answers  


Is nosql faster than sql?

1 Answers  


Categories