In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;

2 Answers   Mastek,

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

4 Answers  

---

What is difference between joins and union?

0 Answers  

---

What is nosql db?

0 Answers  

---

What programs use sql?

0 Answers  

---

Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.

5 Answers   CGI,

---

What are Anti joins

1 Answers   IBM,

---

What are joins in sql?

0 Answers  

---

how to drop an existing table in mysql? : Sql dba

0 Answers  

---

How can use stored procedures in sql?

0 Answers  

---

What is nvarchar in sql?

0 Answers  

---

Explain normalization and what are the advantages of it?

0 Answers  

---