What is Overloading of procedures ?

2 Answers  

---

I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

2 Answers   HSBC,

---

What is Difference between StoredProcedure and function?

3 Answers  

---

How do I write a sql query in pgadmin 4?

0 Answers  

---

Does truncate require commit?

0 Answers  

---

what is sql optimization

1 Answers   Fidelity,

---

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  

---

With out using count() function. How to the find total number of rows in a table?

6 Answers  

---

Which data dictionary views have the information on the triggers that are available in the database?

0 Answers  

---

take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...

9 Answers   Zensar,

---

What is embedded sql in db2?

0 Answers  

---

How did you export data from database to excel file.

1 Answers   TCS,

---