(adsbygoogle = window.adsbygoogle || []).push({});
The delete command is used to remove rows from a Table.
A where clause can be used to only remove some rows.if no where condition is specified,all rows will be removed.
After performing a delete operation you need to commit or Rollback the transaction to make the change permanent or to...
Thursday, March 26, 2015
Sunday, March 15, 2015
Using Clause In Sql
The Using Clause specifies which columns to test for equality when two tables are joined.it can be used insted of an on clause in the join operation that have an explicit join clause.
Syntax:-
Using(simple-column name[,simple column name]*)
The Columns listed in the using clause mumst be present in both of two being joined.The USING clause will...
Tuesday, March 3, 2015
Distinct Function
The SQL SELECT DISTINCT Statement
In a table, some of the columns may contain duplicate values. This is not a problem, however,
sometimes you will want to list only the different (distinct) values in a table.
The DISTINCT keyword can be used to return only distinct (different) values.
SQL SELECT DISTINCT Syntax
SELECT DISTINCT column_name(s)
FROM...
