Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,

---

how to install mysql? : Sql dba

0 Answers  

---

How do you change a value in sql?

0 Answers  

---

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 pl sql and why it is used for?

0 Answers  

---

Can you create a table with Primary Key not as the clustered index.

2 Answers   CGI,

---

what command is used to create a table by copying the structure of another table including constraints ?

6 Answers   CMC, eicc,

---

Can we join two tables without common column?

0 Answers  

---

what is the output of this query selet * from employee where 1=2 ??

11 Answers  

---

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  

---

What is a database link?

3 Answers  

---

What are sql queries used for?

0 Answers  

---