How many sql are there?

0 Answers  

---

wirte a query to remove null? following table are col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output like col1 col2 col3 dinesh suresh prkaesh

6 Answers   TCS,

---

Where the integrity constrints are stored in Data Dictionary?

1 Answers  

---

What is the need of merge statement?

0 Answers  

---

What is error ora-01000: maximum open cursors exceeded

0 Answers  

---

What are sql triggers used for?

0 Answers  

---

What is query syntax?

0 Answers  

---

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

0 Answers  

---

What is the advantage of nosql?

0 Answers  

---

What is pl/sql table? Why is it used?

0 Answers  

---

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for example emp id =5, repeated in two times in rows same id how to delete same empid please any one of the write query send in my id

8 Answers   CGCI,

---

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,

---