adspace


What is case function?

Answer Posted / Praveen Singh

The CASE function in SQL allows conditional evaluation of expressions. It is similar to IF-THEN-ELSE statements in procedural languages. The syntax includes the keyword CASE followed by a series of WHEN conditions, an optional ELSE clause, and an END keyword.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the best sql course?

1050


what is collation? : Sql dba

1229


Can delete statement be rollbacked?

1054


how to start mysql server? : Sql dba

1267


what is schema? : Sql dba

1147


Is inner join faster than left join?

1277


Can we rollback truncate?

1074


What is the current version of postgresql?

1178


what are the advantages of sql ? : Sql dba

1142


what are aggregate and scalar functions? : Sql dba

1129


If a cursor is open, how can we find in a pl/sql block?

1238


What is the current version of sql?

1094


what is sql server agent? : Sql dba

1182


what is bcp? When does it used? : Sql dba

1056


how to use regular expression in pattern match conditions? : Sql dba

1113