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

Explain important index characteristics?

0 Answers  

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

Do you know what is difference between stored procedure and user defined function?

0 Answers  

---

How to execute the cursor queries with "open" statements?

0 Answers  

---

How to call stored procedure using http soap?

0 Answers  

---

Introduction of rollup clause using sum and group by clause?

0 Answers  

---

What is a db view?

0 Answers  

---

Why are views required in the sql server or in any other database?

0 Answers  

---

what is diffrent between store procedure and trigger

2 Answers  

---

Why it is recommended to avoid referencing a floating point column in the where clause?

0 Answers  

---

What is the order in which the sql query is executed?

0 Answers  

---

what is the system function to get the current user's user id? : Sql server database administration

0 Answers  

---