Define implicit and explicit cursors.

0 Answers  

---

What normalization means?

0 Answers  

---

what is SCALAR Queries?

2 Answers   ITC Infotech,

---

What is difference between rank () row_number () and dense_rank () in sql?

0 Answers  

---

I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

1 Answers   IBM, Saama Tech,

---

Does truncate require commit?

0 Answers  

---

Explain 3 basic parts of a trigger.

0 Answers  

---

What is the difference between having and a where in sql?

0 Answers  

---

what are the different types of joins?

4 Answers   Choice Solutions,

---

I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books are 4. (2).Net2.0 books are 3, .Net3.5 books are 2 (3)ABC1.6 books are 4, ABC2.0 books are 3. Now i want output is like Book Count Java 6 .Net 5 ABC 7 For this i need sql query, please help me if anyone how to get this result. Thanks, Seenu

4 Answers   Adea,

---

What is online transaction processing (oltp)?

0 Answers  

---

How can we link a sql database to an existing android app?

0 Answers  

---