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 trigger and types?

0 Answers  

---

What are database links used for?

0 Answers  

---

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the "sales_detail" table contains ten records with different values in the flavor column (two "vanilla," three "chocolate," four "strawberry," and one NULL), how many rows are returned by the sample code above? 1. 0 rows 2. 1 row 3. 3 rows 4. 4 rows 5. 10 rows

8 Answers   Sonata,

---

What does partition by mean in sql?

0 Answers  

---

What is difference between stored procedure and trigger?

0 Answers  

---

Can you join a table to itself?

0 Answers  

---

what is row? : Sql dba

0 Answers  

---

What is data types in sql?

0 Answers  

---

What is raid? How does it help storage of databases?

0 Answers  

---

How to run pl sql program in mysql?

0 Answers  

---

How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?

29 Answers   Alps, Aricent, Bank Of America, Wipro,

---