Answer / Brahma Dev Dwivedi

Yes, when using the BETWEEN operator in SQL, it includes both the start and end values.

Explain the two type of Cursors ?

8 Answers   Hi Caliber IT,

---

What is dense_rank in sql?

1 Answers  

---

what are the types of join and explain each? : Sql dba

1 Answers  

---

Is sqlexception checked or unchecked?

1 Answers  

---

What is materialized view. What are different methods of refresh?

1 Answers  

---

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the "sales_detail" table contains ten records with different values in the flavor column (two "vanilla," three "chocolate," four "strawberry," and one NULL), how many rows are returned by the sample code above? 1. 0 rows 2. 1 row 3. 3 rows 4. 4 rows 5. 10 rows

8 Answers   Sonata,

---

what is an index? : Sql dba

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,

---

How to select all records from the table?

1 Answers  

---

What are the operators used in select statements?

1 Answers  

---

Is not null in sql?

1 Answers  

---

What is a behavioral trigger?

1 Answers  

---