What are the different operators available in sql?

0 Answers  

---

Question: Below is the table city gender name delhi male a delhi female b mumbai male c mumbai female d delhi male e I want the o/p as follows: male female delhi 2 1 mumbai 1 1 Please help me in writing the query that can yield the o/p mentioned above?

2 Answers  

---

What is rollback?

0 Answers  

---

How can I get the number of records affected by a stored procedure?

0 Answers  

---

What is the trigger in sql?

0 Answers  

---

What can sql server reporting services do?

0 Answers  

---

What are the differences between implicit and explicit cursors?

0 Answers  

---

differentiate between float and double. : Sql dba

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 are the benefits of triggers?

0 Answers  

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

0 Answers   Wipro,

---

what are the differences between char and varchar? : Sql dba

0 Answers  

---