SQL Alter Table

The SQL ALTER TABLE is used to add, delete or modify columns in an existing table. SQL Alter Table:- ALTER TABLE table_name ADD column_name datatype Drop Column:- ALTER TABLE table_name … Continue reading “SQL Alter Table”

February 24, 2016 webetutorial

SQL Indexes

Indexes are extraordinary lookup tables that the database web crawler can use to accelerate information recovery. Basically, a list is a pointer to information in a table. An index speeds … Continue reading “SQL Indexes”

February 17, 2016 webetutorial

SQL Select Into

The SELECT INTO statement copies data from one table and inserts into a new table. Syntax:- SELECT * INTO newtable FROM table1; The new table contains the column-names and types … Continue reading “SQL Select Into”

February 17, 2016 webetutorial

SQL Unions

The SQL UNION is used to combine the results of two or more SELECT statements without any duplicate rows. To utilize UNION, each SELECT must have the same number of … Continue reading “SQL Unions”

February 17, 2016 webetutorial

SQL Joins

SQL joins are used to combine rows from two or more tables. The following SQL statement of INNER JOIN:- Example:- SELECT Orders.OrderID, Visitors.CustomerName, Orders.OrderDate FROM Orders INNER JOIN Visitors ON … Continue reading “SQL Joins”

February 17, 2016 webetutorial

SQL Aliases

SQL aliases are used for the moment rename a table or a column title. Mainly aliases are created to make column names more clear. Syntax for Columns:- SELECT column_name AS … Continue reading “SQL Aliases”

February 11, 2016 webetutorial

SQL Top

The SQL TOP or LIMIT phrase is used to obtain TOP N number records from a table. SQL Syntax:- SELECT column_name FROM table_name LIMIT number; Example:- The subsequent SQL query … Continue reading “SQL Top”

December 29, 2015 Command , Query webetutorial

SQL Like

The SQL LIKE query is used to evaluate a value to related values using wildcard operators. You could use two wildcards for conjunction with the LIKE operator…..

December 29, 2015 Command , eTutorial webetutorial

SQL Delete

The DELETE query is used to delete records from table….

December 29, 2015 Command , Delete webetutorial
X
Subscribe to our newsletter
Subscribe to our newsletter today to receive updates on the latest news and offers.
100% Privacy. No spam guaranteed
webe tutorial
Menu