Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 72
  • Last Modified:

How do I write a Delete query in SQL?

In SQL, How do I convert the following select query so that it deletes the selected records?  

SELECT 
  DISTCUST.DISTRIBUTOR,
  DISTCUST.DISTCUSTOMER,
  DISTCUST.CUSTOMER,
  DISTCUST.ZIPCODE,
  DISTCUST.CUSTOMERIDT
FROM
  DISTCUST
WHERE
  DISTCUST.DISTRIBUTOR = '07030'

Open in new window


Thank you.
TH
0
thutchinson
Asked:
thutchinson
1 Solution
 
GaryCommented:
DELETE FROM
  DISTCUST
WHERE
  DISTCUST.DISTRIBUTOR = '07030'

Open in new window

0
 
thutchinsonAuthor Commented:
That did it.  Thank You!
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now