SQL Oracle PHP Java JSP JDBC MORE

SQL WHERE Clause

❮ Previous Next ❯

To select, update, delete specific record from the table where clause is used.

SQL Where Clause use for Select

SELECT column_name,column_name
FROM table_name
WHERE column_name operator value;

The WHERE clause specifies which record or records that should be selet. If you omit the WHERE clause, all records will be select.

SQL Where Clause use for Delete

DELETE column_name,column_name
FROM table_name
WHERE column_name operator value;

The WHERE clause specifies which record or records that should be deleted. If you omit the WHERE clause, all records will be deleted.

SQL Where Clause use for Update

UPDATE table_name
SET column1=value1,column2=value2,...
WHERE some_column=some_value;

The WHERE clause specifies which record or records that should be Update. If you omit the WHERE clause, all records will be Update.

❮ Previous Next ❯