Sharp Tutorial
delete query in sql

Python

Java

C

C++

HTML/CSS

Java Script

PHP

SQL

C Programs

SQL

  • SQL home
  • SQL introduction
  • SQL install and Run
  • create table
  • drop table
  • alter table
  • Insert into table
  • select query
  • Where Clause
  • Order By /Group By
  • Delete Query
  • Update query
  • Aggregate Function
  • Join Tables
  • SQL Examples
  • SQL Exercise

DBMS

delete query in sql

Delete query is used to delete the records from a table. Using Delete query all records may be delete from a table or selected records may be deleted using where clause 

Delete Query Syntax:

delete from <table-name>;

delete from <table-name> <where-clause-optional>;

Delete Query Example

delete from student;

Above query deletes all records from the given student table.

delete from student where course=’bca’;

above query deletes the records whose course is ‘bca’

Enquiry about Course

Ask your Question

Click Here

Sharp (2) Tutorials

Video/ C Introduction

Watch video in full size

Video tutorial

Follow by Email
Facebook
Facebook
fb-share-icon
YouTube
Copyright © Sharp Tutorial
Build with WordPress
Wordpress Social Share Plugin powered by Ultimatelysocial
Sharp Tutorial