how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

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,

---

How many unique keys can a table have?

0 Answers  

---

what is log shipping? : Sql dba

0 Answers  

---

What is recursive join in sql?

0 Answers  

---

What is difference between stored procedures and application procedures?

0 Answers  

---

Can we use pl sql in sql server?

0 Answers  

---

declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....

3 Answers   Satyam,

---

Is ms sql is free?

0 Answers  

---

What is the limitation on the block size of pl/sql?

0 Answers  

---

Is merge a dml statement?

0 Answers  

---

what is the difference between delete and truncate statement in sql? : Sql dba

0 Answers  

---