Answer / Pawan Parimal

SQL comments are used to explain or document SQL statements. They allow developers to include notes and annotations in their code without them being interpreted as actual commands. In most SQL dialects, comments are created using two types of syntax:nn1. Single-line comment: `--` followed by the comment text.n2. Multi-line comment: `/*` at the start of the comment and `*/` at the end.

Can variables be used in sql statements?

1 Answers  

---

I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?

8 Answers   L&T,

---

What is primary key sql?

1 Answers  

---

Why are aggregate functions called so?

1 Answers  

---

What is row_number () in sql?

1 Answers  

---

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

1 Answers  

---

What are inner outer left and right joins in sql?

1 Answers  

---

What is latest version of sql?

1 Answers  

---

How is a process of pl/sql compiled?

1 Answers  

---

Explain the the delete statements in sql?

1 Answers  

---

How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)

3 Answers   TCS,

---

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1 Answers  

---