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  

---

How many rows can sqlite handle?

0 Answers  

---

How do you assign Construct the where clause without concatenating Field,value pairs?

1 Answers   Microsoft,

---

What is an exception in pl/sql?

0 Answers  

---

suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how we will do..?

6 Answers  

---

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,

---

What is sqlca in db2?

0 Answers  

---

how to saw triggers output in pl/sql database?

1 Answers  

---

What is minus?

0 Answers  

---

What is sp_helptext?

0 Answers  

---

Can procedure in a package be overloaded?

1 Answers   HCL,

---

what is the difference between myisam static and myisam dynamic? : Sql dba

0 Answers  

---