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

0 Answers  

---

What do you mean by dbms? What are its different types?

0 Answers  

---

Define concurrency control. : Transact sql

0 Answers  

---

If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)

5 Answers  

---

what is a trigger in mysql? : Sql dba

0 Answers  

---

---

What are the operators in sql?

0 Answers  

---

How to create a menu in sqlplus or pl/sql?

0 Answers  

---

what is a view? : Sql dba

0 Answers  

---

explain advantages of innodb over myisam. : Sql dba

0 Answers  

---

I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

7 Answers   MTS,

---

What are local and global Indexes and where they are useful.

0 Answers  

---

how mysql optimizes distinct? : Sql dba

0 Answers  

---