RoseIndia.net

SQL Tutorial

Programming Resource Home :: Database-Tutorials :: SQL_Tutorial




SQL Tutorial
Tutorial SQL Alias
Alias name is given to table and column. In SQL we can give a table or column another name by using an Alias. View Rating



SQL Tutorial
Tutorial SQL INNER Joins
The JOIN keyword is used in SQL statement to query data from two or more tables, based on a relationship between certain columns in these tables. View Rating



SQL Tutorial
Tutorial SQL PRIMARY KEY Constraint
The PRIMARY KEY constraint is used to uniquely identifies each record in a database table. View Rating



SQL Tutorial
Tutorial SQL OR Operators
The OR operator displays records if any of the conditions is true. View Rating



SQL Tutorial
Tutorial SQL NOT NULL Constraint
The NOT NULL constraint allows a column not to accept NULL values. This specify that NOT NULL Constraint enforce the field to accept a value. View Rating



SQL Tutorial
Tutorial SQL ORDER BY
The ORDER BY keyword sort the table result set by a specified column. You want to sort the records in ascending order, you can use the ASC keyword. View Rating



SQL Tutorial
Tutorial SQL LEFT JOIN
The LEFT JOIN keyword retrieve all rows from the left table (table_name1), even if there are no matches in the right table (table_name2). View Rating



SQL Tutorial
Tutorial SQL SELECT DISTINCT Statement
In this example we will show you the usage of Distinct clause with the select statement. View Rating



SQL Tutorial
Tutorial LIKE Operator
The LIKE operator is used for searching a specified pattern in the column. In this example we will show you how to use the Like operator to get the related results from the database. View Rating



SQL Tutorial
Tutorial SQL _ Wildcards
SQL wildcards are used for searching one or more characters from data in a database. View Rating
Page:  [<<]   1   2   3   4   5   6   7   8   9   10   11   12   13   14   15   16   17   18   19   20   21   22   23   24   25   26   27   28   29   30     [>>]


Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright 2004. All rights reserved.