Jump to content

Learning SQL 2nd Ed

Giritharan's Photo
Posted Jul 24 2011 03:56 AM
2900 Views

In the Subqueries chapter(Chapter 9), the author says "Subqueries are a powerful tool that you can use in all four SQL data statements". I don't understand what is meant by "all four SQL data statements". Does it mean CRUD?

Tags:
1 Subscribe


1 Reply

0
  macnlos's Photo
Posted Jul 24 2011 10:54 AM

This is an excerpt from another website that describes the four basic types of SQL statements:


SQL commands fall into one of 4 categories:

SELECT - Retrieving data from one or more tables
INSERT - Adding rows to a table
UPDATE - Modifying existing rows in a table
DELETE - Deleting one or more rows from a table


Website: http://www.sql-serve...l-commands.html
=========================
Sent to you from my
iPad, iPhone, BlackBerry,
Laptop, Desktop, or
Kitchen Toaster