Answer / Vikash Kumar Sinha

Scalar functions are SQL functions that return a single value. Examples include LENGTH(), LOWER(), UPPER(), and ABS(). They can be used to perform various operations on individual values within a column or expression.

what is Difference between Having and Where clause?

5 Answers   IBM,

---

What is %s in sql?

1 Answers  

---

What is the non-clustered index in sql?

1 Answers  

---

Describe different types of general function used in sql?

1 Answers  

---

What is Histogram?

1 Answers   NIIT,

---

How is sql used in oracle?

1 Answers  

---

Begin For j in 4403201000 .. 4403202000 Loop If mod (j, 100) = 0 then Dbms_output.put_line (j); End if; End loop; End; what will be the output of this question

7 Answers   TCS,

---

Can a varchar be a primary key?

1 Answers  

---

How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?

1 Answers   Parexel,

---

what is unique key constraint? : Sql dba

1 Answers  

---

I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible

9 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,

---