Answer / karthik soundararajan

TableA -- Existing Table

ID
5
5
5
5
5

Solution : SELECT DISTINCT ID INTO TableB FROM TableA

It create a table called TableB and insert only one record as shown below:

ID
5

Answer / sheshu4040

SELECT DISTINCT * INTO TABLE_NEW FROM TABLE_EXISTING

How to delete existing triggers using "drop trigger"?

0 Answers  

---

What is the name of the Database which IBM mainframe uses?

0 Answers   Wipro,

---

what are the different ways to return the rowcount of a table?

0 Answers   Microsoft,

---

How many primary keys are possible in a table?

0 Answers  

---

Why truncate is ddl command?

0 Answers  

---

Creating Tables Using SELECT

1 Answers  

---

in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

8 Answers  

---

What do you understand by triggers?

0 Answers  

---

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

0 Answers  

---

What is nolock hint in sql server 2008

0 Answers   HCL,

---

How to a Query to copy data from on table to another table.

6 Answers   Cap Gemini,

---