one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

9 Answers   TCS,

---

What is difference between stored procedure and trigger?

0 Answers  

---

what is the difference between union and union all? : Sql dba

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,

---

Why does %isopen return false for an implicit cursor?

1 Answers  

---

What are string functions in sql?

0 Answers  

---

What is the difference between distinct and unique in sql?

0 Answers  

---

What are dml commands?

0 Answers  

---

how many values can the set function of mysql take? : Sql dba

0 Answers  

---

What is natural join in sql?

0 Answers  

---

What does stand for in sql?

0 Answers  

---

What is meant by truncate in sql?

0 Answers  

---