Quality Testing

Quality is delighting customers

Dear friends ,

 

Can you please share with me SQL quesries for

1) Deleting duplicate rows from a particular table.

2) Fetch say 29th row from a table having 40 rows

Views: 179

Reply to This

Replies to This Discussion

1.Delet from product where globalpartno in(Select globalpartno as total from product groupby globalpartno having count(globalpartno)>1

RSS

TTWT Magazine


Advertisement

Advertisement

Advertisement

Advertisement

© 2019   Created by Quality Testing.   Powered by

Badges  |  Report an Issue  |  Terms of Service