Answer Posted / 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;

What is the current version of postgresql?

1178

---

What is the best sql course?

1050

---

what is schema? : Sql dba

1147

---

what are the advantages of sql ? : Sql dba

1142

---

Can we rollback truncate?

1074

---

Does group by remove duplicates?

1112

---

Do we need to rebuild index after truncate?

1138

---

what is dbms? : Sql dba

1061

---

how many tables will create when we create table, what are they? : Sql dba

1144

---

Is inner join faster than left join?

1277

---

how to escape special characters in sql statements? : Sql dba

1114

---

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

1056

---

what is sql server agent? : Sql dba

1182

---

What is your daily office routine?

2346

---

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

1113

---