write a query to remove duplicate records without using primary key column?

2 Answers   ABCO,

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---

What area unit the various kinds of info compression introduced in sql server 2008?

0 Answers  

---

Why we need a group by clause?

4 Answers  

---

How to find the date and time of last updated table?

3 Answers  

---

What happens if null values are involved in bitwise operations?

0 Answers  

---

What are the indexes in sql server?

0 Answers  

---

After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?

0 Answers   Cognizant,

---

What is the purpose of UPDATE STATISTICS?

2 Answers  

---

Can you explain the disadvantages/limitation of the cursor?

0 Answers  

---

how we can count records as a group of days like sum of records for(four mondays),(four tuesday)........ in a month. group the column for weekdays.

1 Answers  

---

What is the difference between coalesce() & isnull()?

0 Answers  

---