Answer / venkat

if u r table like this
sno sname fee
1 a 1000
1 a 1000
2 b 1000
2 b 1000
3 c 1000
3 c 1000
--- write this
with duplicatecte
as
(select row_number()over(partition by sno,sname order by fee
)as rnum from students )
delete from dupcte where rnum>1

---run this query
select * from students
--out put is
1 a 1000
2 b 1000
3 c 1000

this is correct

can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?

1 Answers  

---

When would you use sql joins?

0 Answers  

---

Can you explain about buffer cash and log cache in sql server?

0 Answers  

---

How to receive output values from stored procedures?

0 Answers  

---

How to optimize stored procedure optimization?

0 Answers  

---

Explain why variables called the most powerful component of ssis?

0 Answers  

---

What is database white box testing?

0 Answers  

---

What is usually the first word in a sql query?

0 Answers  

---

How many non clustered indexes there can be on table ?

0 Answers  

---

What are different types of join?

0 Answers  

---

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---

How to provide default values to function parameters?

0 Answers  

---