Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

4 Answers   Cap Gemini, IBM,

---

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for example emp id =5, repeated in two times in rows same id how to delete same empid please any one of the write query send in my id

8 Answers   CGCI,

---

how many columns can be used for creating index? : Sql dba

0 Answers  

---

What program will open a mdb file?

0 Answers  

---

how to include comments in sql statements? : Sql dba

0 Answers  

---

What is offset and limit in sql?

0 Answers  

---

what is 'mysqladmin' in mysql? : Sql dba

0 Answers  

---

How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')

2 Answers  

---

HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY BE USING SCRIPT)

8 Answers   BeBo Technologies,

---

How to use transactions efficiently : transact sql

0 Answers  

---

In what condition is it good to disable a trigger?

0 Answers  

---

What is the usage of sql functions?

0 Answers  

---