name 3 ways to get an accurate count of the number of records in a table? : Sql dba

0 Answers  

---

Can we update views in sql?

0 Answers  

---

who introduced sql?

0 Answers  

---

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 bulk collections?

2 Answers  

---

Give an example of any procedure.

5 Answers   Accenture, iFlex, Wipro,

---

How do I access sql anywhere database?

0 Answers  

---

What is the use of function in sql?

0 Answers  

---

Types of cursor locks and explanation each of them ?

3 Answers   DELL, HP Finsoft,

---

How to avoid using cursors?

0 Answers  

---

How many primary keys can a table have?

0 Answers  

---

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

3 Answers   JPMorgan Chase,

---