Answer / Rahul Anand

To rename an existing column in a MySQL table, you can use the ALTER TABLE command with the RENAME COLUMN statement. Here's an example: `ALTER TABLE your_table RENAME COLUMN old_column_name TO new_column_name`.

A table has 150 records. How do you retrieve 100th row to 120th row from that table ?

21 Answers   IBM,

---

What is primary and foreign key?

1 Answers  

---

How many functions are there in sql?

1 Answers  

---

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,

---

What is join view in sql?

1 Answers  

---

what is user defined functions? : Sql dba

1 Answers  

---

How can I create a table from another table without copying any values from the old table?

8 Answers  

---

What is cartesian join in sql?

1 Answers  

---

find the third highest salary?

23 Answers  

---

What is mdb stand for?

1 Answers  

---

What is materialized view. What are different methods of refresh?

1 Answers  

---

What is the need of merge statement?

1 Answers  

---