Quality Testing

Quality is delighting customers

SQL queries to fetch some records

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: 4

▶ Reply to This

Replies to This Discussion

Permalink Reply by nidhi on April 21, 2010 at 3:45pm
1.Delet from product where globalpartno in(Select globalpartno as total from product groupby globalpartno having count(globalpartno)>1

RSS

TTWT Magazine

Advertisement

You Can


Call for Articles

Advertisement

Quality Jobs Portal

Performance Lead

Test Engineer

QTP Test Analyst – Miminum 2 years in QTP and 4 to 5 years in testing. This position is for one our client in western mumbai

Contract QA Engineer

Online Trainers

Videos

  • Add Videos
  • View All

Badge

Loading…

Get Badge

© 2012   Created by Quality Testing.

Badges  |  Report an Issue  |  Terms of Service

Sign in to chat!