What do you mean by table in sql?

0 Answers  

---

How do you update a table in sql?

0 Answers  

---

How to handle bulk data?

0 Answers  

---

What are the types of join in sql?

0 Answers  

---

how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  

---

What are the rules to be applied to nulls whilst doing comparisons?

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  

---

Name some usages of database trigger?

0 Answers  

---

Are null values same as that of zero or a blank space?

0 Answers  

---

What is pl/sql language case sensitive?

0 Answers  

---

what is the difference between group by and order by in sql? : Sql dba

0 Answers  

---

ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

2 Answers  

---