SQL Subquery with WHERE and Delete

Sub-queries return one value or list of values to the calling or main query. The query within the main query you can call it as a nested query. In my previous post, I have covered – How to Write a Subquery Quickly in SELECT Statement.


The use of WHERE (to filter rows), and DELETE a row very much common in sub-queries. So you can filter rows and delete a row. My examples will give you clear idea on how to write SQL queries. So that you can use in your projects today.

SQL WHERE and DELETE Using Sub-query

Subscribe to get access.

Read more of this content when you subscribe today.

Recent Posts

2 Amazing Ways to Limit Rows in Oracle SQL Query

These two ways limit the number of rows return from an SQL query. These are helpful for Oracle and other SQL developers.

Download COBOL Tutorial

Related Posts

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.