how do you know the version of your mysql server? : Sql dba

0 Answers  

---

How many row comparison operators are used while working with a subquery?

0 Answers  

---

how to get @@error and @@rowcount at the same time? : Sql dba

0 Answers  

---

Show the two pl/sql cursor exceptions.

0 Answers  

---

how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OBS Name Sal 105 E 5000--> 105 E 5000 102 B 2000 104 D 4000 103 C 3000 101 A 1000--> 104 D 4000

4 Answers  

---

How many indexes can be created on a table in sql?

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

---

Are stored procedures faster than queries?

0 Answers  

---

How to combine two stored procedures in sql?

0 Answers  

---

i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75

12 Answers   IBM,

---

I want to execute a piece of code before calling a procedure. How to achieve it?

1 Answers   Oracle,

---

What is the use of a view in sql?

0 Answers  

---