Saturday, 10 December 2016

SQL TUTORIAL - PART 5

SQL TUTORIAL - PART 5

SQL ALIAS

In addition, aliasing can be used as an obfuscation technique to protect the real names of database fields.

sql update alias


ID BookName Price Year Domain AuthorName
1 The Practical SQL Handbook 180 2009 Database Ranjani Mai
2 Complete Guide To No-SQL 105 2009 Performance Bala Murugan
3 SQL Made Simple... By Examples 160 2006 Security Keshavan
4 Sql Server T-sql By Example 125 2009 Performance Dharan

SQL ALTER TABLE

The SQL ALTER TABLE command is used to modify the definition (structure) of a table by modifying the definition of its columns.

alter table add foreign key


ID BookName Price Year Domain AuthorName
1 Learing Sql Server T-Sql 99.99 2015 Database Geetha
2 SQL in Easy Steps 71.87 2012 Performance Dharan
3 Microsoft SQL Server 2012 90 2012 Programming Padmavathi
4 Practical SQL 136.33 2006 Database Hari Krishnan

SQL AND OR

How to use SQL logical operators AND, OR, NOT. A tutorial on SQL programming. Your Guide in learning SQL.

in and not in sql


ID BookName Price Year Domain AuthorName
1 MySql Interview Questions 71.87 2012 Optimization Bala Murugan
2 SQL For Microsoft Access 185 2015 Performance Rishi Keshan
3 The SQL Programming Language 75 2009 Database Keshavan
4 Microsoft SQL Server 2012 Bible 145 2008 Programming Keshavan

SQL AUTO INCREMENT

The IDENTITY property is different from the sql/sql-DMO Identity property that exposes the ... Each new value is generated based on the current seed & increment.

auto-increment sql


ID BookName Price Year Domain AuthorName
1 MySQL: The Complete Reference 130 2014 Security Chandra
2 Beginning SQL Queries 99.99 2015 Administration Padmavathi
3 Pro MySql Administration 84.22 2009 Database Siva Kumar
4 Professional Microsoft SQL Server 70 2013 Optimization Vinoth Kumar

SQL BETWEEN

SQL BETWEEN ... AND Operator. The operator BETWEEN and AND, are used to compare data for a range of values.

between in sql


ID BookName Price Year Domain AuthorName
1 Postgre Sql Server Programming 110 2006 Performance Sakunthala
2 Oracle Database Internals 70 2010 Performance Sakunthala
3 Oracle Cookbook 60 2010 Performance Chandra
4 MySql for professionals 150 2006 Database Azaghu Varshith

SQL CHECK

SQL CHECK constraint check specified specific condition, which must evaluate to true for constraint to be satisfied.

check sql


ID BookName Price Year Domain AuthorName
1 MySql Concurrency 180 2009 Optimization Dharan
2 Introduction to SQL and PL/SQL 205 2009 Administration Vinoth Kumar
3 The Gurus Guide To SQL Server 84.22 2012 Performance Pandurengan
4 Simply MySql 115 2008 Security Pandurengan

SQL CREATE TABLE

How to create table in sql. How to create a database table. How to create SQL table. A tutorial on SQL programming.

create temporary table


ID BookName Price Year Domain AuthorName
1 Foundations Of Sql Server 2008 205 2006 Performance Vidyavathi
2 MySql Query Performance Tuning 145 2012 Administration Sakunthala
3 Teach Yourself SQL in 10 Minutes 155 2008 Administration Geetha
4 Oracle Query Performance Tuning 71.87 2011 Administration Balan

SQL DEFAULT

The DEFAULT value clause in a data type specification indicates a default value ... MySQL handles the column according to the SQL mode in effect at the time:.

alter table add column with default


ID BookName Price Year Domain AuthorName
1 Complete Guide To No-SQL 85 2009 Optimization Chandra
2 Troubleshooting Oracle 90 2010 Administration Sakunthala
3 SQL Server 2012 Black Book 130 2010 Security Ramanathan
4 Practical SQL 185 2009 Programming Geetha

SQL DELETE

Some DBMSs, like MySQL, allow deletion of rows from multiple tables with one DELETE statement (this is sometimes called multi-table DELETE).

delete row in sql


ID BookName Price Year Domain AuthorName
1 The Microsoft Data Warehouse 115 2006 Performance Siva Kumar
2 SQL Made Simple... By Examples 136.33 2013 Administration Hari Krishnan
3 Access 2010 Pure Sql 60 2015 Programming Nirmala
4 Microsoft SQL Server 2012 Bible 84.22 2006 Administration Pandurengan

SQL DISTINCT

The distinct keyword is used with Select statement to retrieve unique values from the table. Distinct removes all the duplicate records while retrieving from database tables.

sql server distinct


ID BookName Price Year Domain AuthorName
1 SQL Functions Reference 185 2009 Optimization Harish Karthik
2 Professional MySql 165 2012 Security Sakunthala
3 SQL Server Fundamentals 95 2006 Programming Chandra
4 Oracle All-in-One For Dummies 75 2009 Database Chandra

SQL FOREIGN KEY

In the context of relational databases, a foreign key is a field (or collection of fields) in one table.

foreign key definition


ID BookName Price Year Domain AuthorName
1 SQL Pocket Guide 99.99 2011 Database Ranjani Mai
2 Sql Server Concurrency 80 2013 Optimization Ramanathan
3 Learing Sql Server T-Sql 95 2013 Optimization Sakunthala
4 SQL Programming & Database Design 165 2009 Performance Rishi Keshan

SQL FULL JOIN

The SQL full join is the result of combination of both left and right outer join and the join tables have all the records from both tables.

full outer join sql


ID BookName Price Year Domain AuthorName
1 Simply SQL 90 2015 Programming Padmavathi
2 The Microsoft Data Warehouse 123.45 2011 Performance Nirmala
3 Understanding the New SQL 70 2015 Performance Sakunthala
4 Learing Sql Server T-Sql 85 2012 Performance Devi Mai

SQL FUNCTION ABS

This Oracle tutorial explains how to use the Oracle / PLSQL ABS function with syntax and examples.

oracle absolute value


ID BookName Price Year Domain AuthorName
1 Teach Yourself SQL in 10 Minutes 150 2008 Database Chandra
2 Learing Sql Server T-Sql 80 2011 Programming Sakunthala
3 MySql Database Internals 140 2015 Security Balan
4 Head First SQL Brain On SQL 185 2013 Database Nirmala

SQL FUNCTION AVG

The 1Keydata SQL Tutorial teaches beginners the building blocks of SQL. This section explains how to use the AVG function.

mssql average


ID BookName Price Year Domain AuthorName
1 The Complete Guide to Oracle 190 2015 Security Dharan
2 Beginning SQL Queries 100 2013 Administration Ramanathan
3 SQL Server All-in-One For Dummies 165 2013 Administration Siva Kumar
4 Securing Oracle 110 2011 Programming Hanumanthan

SQL FUNCTION CEILING

Returns the ceiling (smallest integer not less than) of a number.

sql server ceiling


ID BookName Price Year Domain AuthorName
1 SQL in Easy Steps 123.45 2011 Programming Keshavan
2 MySql Database Internals 60 2012 Programming Pandurengan
3 SQL Fundamentals 120 2010 Optimization Azaghu Varshith
4 How to Write Accurate SQL Code 170 2013 Performance Sakunthala

SQL FUNCTION CHARINDEX

Sql charindex is a sql server function that indicates the first position of a character or a character string within another character string.

charindex sql server


ID BookName Price Year Domain AuthorName
1 Securing MySql 200 2007 Programming Hari Krishnan
2 Sql Server Concurrency 155 2009 Security Ranjani Mai
3 How to Write Accurate SQL Code 115 2006 Optimization Harish Karthik
4 The Complete Guide to SQL 123.45 2010 Performance Dharan

SQL FUNCTION CONCAT

MySQL CONCAT() function is used to add two or more strings.

concat sql server


ID BookName Price Year Domain AuthorName
1 Oracle: The Complete Reference 155 2009 Optimization Devi Mai
2 Oracle Fundamentals 130 2008 Security Rishi Keshan
3 SQL in Easy Steps 150 2015 Performance Pandurengan
4 Oracle Query Performance Tuning 75 2011 Administration Varshini Kutty

SQL FUNCTION COUNT

The SQL COUNT function returns the number of rows in a table satisfying the criteria specified in the WHERE clause.

postgresql count


ID BookName Price Year Domain AuthorName
1 Pro SQL Azure 150 2013 Performance Rishi Keshan
2 The Database Language SQL 75 2009 Programming Vinoth Kumar
3 Programming With Oracle 178.69 2013 Performance Geetha
4 SQL Design Patterns 180 2008 Administration Devi Mai

SQL FUNCTION DATEADD

The 1Keydata SQL Tutorial teaches beginners the building blocks of SQL. This section explains the DATEADD function.

dateadd sql server


ID BookName Price Year Domain AuthorName
1 MySQL Cookbook 155 2009 Programming Chandra
2 MySql Query Performance Tuning 160 2006 Security Balan
3 Data Analysis Using SQL 190 2013 Administration Azaghu Varshith
4 The Complete Guide to SQL Server 60 2010 Administration Pandurengan

SQL FUNCTION DATEDIFF

SQL Server DATEADD and DATEDIFF functions allow you to easily perform calculations such as adding or subtracting a time interval from a datetime value.

datediff sql server


ID BookName Price Year Domain AuthorName
1 MySql Fundamentals 110 2015 Optimization Chandra
2 SQL: The Complete Reference 140 2010 Programming Dharan
3 Oracle 11g PL/SQL Programming 190 2011 Programming Varshini Kutty
4 SQL For Microsoft Access 136.33 2012 Administration Sakunthala

SQL FUNCTION DATEPARTS

The SQL Tutorial beginners section explains the DATEPART function.

datepart sql


ID BookName Price Year Domain AuthorName
1 MySql Database Internals 71.87 2014 Database Ranjani Mai
2 MySql for professionals 70 2007 Security Hanumanthan
3 Pro SQL Azure 140 2009 Performance Vidyavathi
4 Microsoft SQL Server 2012 190 2015 Performance Hanumanthan

SQL FUNCTION FLOOR

The FLOOR function returns the largest integer less than or equal to the round value.

function floor


ID BookName Price Year Domain AuthorName
1 Pro Oracle Administration 120 2007 Programming Padmavathi
2 Foundations Of Sql Server 2008 190 2015 Optimization Vidyavathi
3 Making Sense Of SQL 180 2008 Administration Vinoth Kumar
4 Getting Started With SQL 175 2013 Administration Varshini Kutty

SQL FUNCTION MAX

SQL MAX() function with GROUP by, ORDER by: How the GROUP BY and ORDER BY clause along with the SQL MAX() can be used to find maximum value.

max function


ID BookName Price Year Domain AuthorName
1 Oracle Database 11G New Features 190 2011 Security Geetha
2 A Visual Introduction To Sql 130 2014 Performance Keshavan
3 Oracle Fundamentals 165 2014 Programming Devi Mai
4 My SQL Complete Reference 136.33 2014 Security Vidyavathi

SQL FUNCTION MID

The 1Keydata SQL Tutorial teaches beginners the building blocks of SQL. This section explains the SUBSTRING function.

sql server mid


ID BookName Price Year Domain AuthorName
1 SQL Server 2008 Transact-Sql 65 2014 Administration Sakunthala
2 Oracle Cookbook 75 2012 Administration Keshavan
3 MySql Interview Questions 60 2007 Administration Vinoth Kumar
4 Mastering Oracle SQL 85 2015 Database Balan

SQL FUNCTION MIN

SQL MIN() function with group by ... In this page we are going to discuss, how the GROUP BY clause along with the SQL MIN() can be used.

min sql


ID BookName Price Year Domain AuthorName
1 From Access To SQL Server 95 2011 Security Varshini Kutty
2 Data Analysis Using SQL 205 2015 Administration Vidyavathi
3 Troubleshooting SQL Server 70 2012 Optimization Hanumanthan
4 Simply Oracle 99.99 2008 Programming Keshavan

SQL FUNCTION NOW

The Microsoft Access Now function returns the current system date and time.

sql server date now


ID BookName Price Year Domain AuthorName
1 Teach Yourself SQL 80 2007 Security Pandurengan
2 The Complete Guide to Oracle 125 2010 Security Devi Mai
3 SQL Programming & Database Design 110 2010 Programming Padmavathi
4 My SQL Complete Reference 145 2015 Security Nirmala

SQL FUNCTION RAND

Seeding SQL RAND() Method With NEWID() For Per-Row Random.

sql server random string


ID BookName Price Year Domain AuthorName
1 Oracle Query Performance Tuning 75 2006 Database Balan
2 SQL Made Simple... By Examples 175 2008 Optimization Harish Karthik
3 MySql Concurrency 140 2009 Optimization Varshini Kutty
4 Data Analysis Using SQL 80 2009 Performance Ramanathan

SQL FUNCTION REPLACE

REPLACE returns char with every occurrence of search-string replaced with replacement-string.

sql server replace function


ID BookName Price Year Domain AuthorName
1 The SQL Programming Language 70 2009 Database Nirmala
2 Foundations Of Sql Server 2008 200 2013 Optimization Hanumanthan
3 MySQL: The Complete Reference 165 2011 Security Vidyavathi
4 Oracle Concurrency 160 2006 Security Rishi Keshan

SQL FUNCTION ROUND

The ROUND function returns a number that is rounded to the specified number of places to the right or left of the decimal place.

round in sql


ID BookName Price Year Domain AuthorName
1 Simply MySql 168.27 2015 Optimization Harish Karthik
2 Database Management 115 2009 Performance Azaghu Varshith
3 SQL Pocket Guide 90 2011 Database Balan
4 Complete Guide To No-SQL 195 2007 Optimization Padmavathi

SQL FUNCTION SQRT

The SQL SQRT Function is one of the Mathematical Function which is used to find the square root of the specified expression or numeric value.

sql server sqrt


ID BookName Price Year Domain AuthorName
1 Pro MySql Administration 165 2014 Security Harish Karthik
2 MySql for professionals 205 2009 Administration Varshini Kutty
3 Professional Microsoft SQL Server 125 2007 Programming Hanumanthan
4 Getting Started With SQL 168.27 2014 Administration Hanumanthan

SQL FUNCTION SUM

The SQL SELECT COUNT, SUM, and AVG syntax. The general COUNT syntax is: SELECT COUNT(column-name); FROM table-name.

select sum


ID BookName Price Year Domain AuthorName
1 SQL Programming & Database Design 190 2011 Programming Padmavathi
2 Making Sense Of SQL 65 2009 Administration Bala Murugan
3 SQL Puzzles & Answers 199.97 2015 Programming Vidyavathi
4 Securing MySql 185 2007 Optimization Devi Mai

SQL GROUP BY

Group by clause is used to group the results of a SELECT query based on one or more columns. It is also used with SQL functions to group the result from one or more tables.

group by clause


ID BookName Price Year Domain AuthorName
1 Pro SQL Azure 70 2014 Security Geetha
2 Learing Sql Server T-Sql 84.22 2008 Administration Nirmala
3 Practical SQL 71.87 2010 Optimization Pandurengan
4 Postgre Sql Server Programming 145 2006 Performance Padmavathi

SQL HAVING

The SQL HAVING clause is used in combination with the GROUP BY clause to restrict the groups of returned rows to only those whose the condition is TRUE.

oracle having


ID BookName Price Year Domain AuthorName
1 Professional MySql 99.99 2006 Database Ramanathan
2 Practical SQL 190 2008 Security Azaghu Varshith
3 Beginning SQL Queries 136.33 2006 Administration Ranjani Mai
4 Art Of SQL 165 2012 Performance Geetha

SQL IN

To accommodate this, SQL allows the use of the IN operator. In SQL, there are two uses of the IN keyword, and this section introduces the one that is related to or operator.

alias in sql


ID BookName Price Year Domain AuthorName
1 Transact SQL Cookbook 130 2008 Programming Keshavan
2 Making Sense Of SQL 99.99 2010 Programming Harish Karthik
3 Sql Server T-sql By Example 60 2008 Administration Ramanathan
4 Art Of SQL 160 2008 Optimization Sakunthala

SQL INNER JOIN

The INNER JOIN selects all rows from both participating tables as long as there is a match between the columns.

inner join and outer join


ID BookName Price Year Domain AuthorName
1 Mastering Oracle SQL 71.87 2006 Database Chandra
2 Oracle Concurrency 195 2008 Performance Keshavan
3 Pro Oracle SQL 136.33 2010 Database Azaghu Varshith
4 Simply Oracle 199.97 2008 Programming Harish Karthik

SQL INSERT INTO

You can use a select-statement within an INSERT statement to insert zero, one, or more rows into a table from the result table of the select-statement.

insert into sql server


ID BookName Price Year Domain AuthorName
1 Simply Oracle 190 2012 Optimization Varshini Kutty
2 MySql Database Internals 95 2015 Programming Dharan
3 Access 2010 Pure Sql 105 2010 Programming Nirmala
4 Troubleshooting Oracle 170 2011 Administration Keshavan

SQL INSERT INTO SELECT

SQL insert into select query with sql, tutorial, examples, insert, update, delete, select, join, database, table, join.

sql server insert into select


ID BookName Price Year Domain AuthorName
1 Jump Start MySQL 70 2015 Database Vidyavathi
2 Red Gate Guide to SQL Server 84.22 2014 Database Bala Murugan
3 Programming With MySQL 90 2006 Database Geetha
4 SQL For Microsoft Access 60 2015 Optimization Ramanathan

SQL LEFT JOIN

A LEFT OUTER JOIN is one of the JOIN operations that allow you to specify a join clause. It preserves the unmatched rows from the first (left) table, joining them into roght table.

left join vs inner join


ID BookName Price Year Domain AuthorName
1 SQL Puzzles & Answers 140 2008 Programming Chandra
2 The Complete Guide to SQL 170 2013 Optimization Bala Murugan
3 SQL Server Fundamentals 60 2014 Database Sakunthala
4 Troubleshooting SQL Server 205 2007 Performance Rishi Keshan

SQL LIKE

The SQL LIKE condition allows you to use wildcards to perform pattern matching in a query. The LIKE condition is used in the WHERE clause of a SELECT statement.

mssql like


ID BookName Price Year Domain AuthorName
1 Postgre Sql Server Programming 160 2010 Security Nirmala
2 SQL and Relational Theory 90 2014 Administration Rishi Keshan
3 Understanding the New SQL 115 2010 Performance Vinoth Kumar
4 SQL in a Nutshell 65 2009 Security Vidyavathi

SQL NOT NULL

Adds a not-null constraint to an existing table.

not null


ID BookName Price Year Domain AuthorName
1 Sql Server Concurrency 84.22 2014 Administration Vinoth Kumar
2 Data Analysis Using SQL 178.69 2013 Security Rishi Keshan
3 Simply SQL 90 2012 Performance Siva Kumar
4 SQL For Microsoft Access 175 2011 Administration Geetha

SQL ORDER BY

Order by clause is used with Select statement for arranging retrieved data in sorted order. The Order by clause by default sort data in ascending order.

sql order by ascending


ID BookName Price Year Domain AuthorName
1 Foundations Of Sql Server 2008 70 2010 Administration Ranjani Mai
2 Introduction to SQL and PL/SQL 130 2015 Database Bala Murugan
3 SQL and Relational Theory 160 2015 Administration Ramanathan
4 SQL Made Simple... By Examples 178.69 2010 Programming Hari Krishnan

SQL PRIMARY KEY

Now the only problem with this SQL CREATE TABLE statement is that you have not defined a primary key for the table.

alter table add primary key


ID BookName Price Year Domain AuthorName
1 Troubleshooting SQL Server 100 2007 Security Geetha
2 Data Analysis Using SQL 105 2009 Optimization Pandurengan
3 Securing Oracle 130 2014 Administration Azaghu Varshith
4 SQL Puzzles & Answers 95 2012 Security Azaghu Varshith

SQL RIGHT JOIN

SQL Server uses the following ISO keywords for outer joins specified in a FROM clause: ... Here is the Transact-SQL query and results of the right outer join.

sql right


ID BookName Price Year Domain AuthorName
1 Mastering Oracle SQL 170 2010 Administration Sakunthala
2 Easy Oracle PL/SQL Programming 80 2008 Optimization Ranjani Mai
3 Professional MySql 168.27 2009 Performance Sakunthala
4 SQL for students 90 2008 Security Geetha

SQL SELECT

SELECT can also be used to retrieve rows computed without reference to any table. In general, clauses used must be given in exactly the order shown in the syntax description.

select statement


ID BookName Price Year Domain AuthorName
1 Microsoft SQL Server 2012 155 2006 Administration Devi Mai
2 Professional Oracle 160 2012 Optimization Nirmala
3 Securing MySql 120 2015 Optimization Bala Murugan
4 Simply SQL Server 150 2013 Programming Keshavan

SQL TOP

Limits the rows returned in a query result set to a specified number of rows or percentage of rows in SQL Server 2016. When TOP is used in conjunction with the other table.

sql top


ID BookName Price Year Domain AuthorName
1 Data Analysis Using SQL 136.33 2009 Administration Vidyavathi
2 SQL Design Patterns 100 2010 Performance Nirmala
3 Oracle All-in-One For Dummies 123.45 2013 Administration Hari Krishnan
4 SQL in Easy Steps 120 2009 Optimization Rishi Keshan

SQL UNION

You can combine multiple queries using the set operators UNION , UNION ALL , INTERSECT, and MINUS . All set operators have equal precedence.

difference between union and union all


ID BookName Price Year Domain AuthorName
1 The Practical SQL Handbook 65 2006 Administration Hari Krishnan
2 Red Gate Guide to SQL Server 199.97 2013 Optimization Ramanathan
3 Pro MySql Administration 200 2012 Performance Vidyavathi
4 Database Systems Using Oracle 190 2012 Security Geetha

SQL UNIQUE

It is possible to put UNIQUE constraints on nullable columns but the SQL standard states that the constraint does not support duplicate values.

unique sql


ID BookName Price Year Domain AuthorName
1 The SQL Programming Language 130 2009 Performance Rishi Keshan
2 The Complete Guide to SQL 175 2012 Performance Ramanathan
3 Oracle Cookbook 190 2015 Administration Varshini Kutty
4 Easy Oracle PL/SQL Programming 95 2015 Performance Hari Krishnan

SQL UPDATE

For the single-table syntax, the UPDATE statement updates columns of existing rows in the named table with new values. The SET clause indicates which columns to modify and the values they should be given.

sql update value


ID BookName Price Year Domain AuthorName
1 SQL Fundamentals 200 2013 Optimization Azaghu Varshith
2 Simply SQL Server 120 2011 Administration Nirmala
3 The Gurus Guide To SQL Server 170 2007 Administration Varshini Kutty
4 MySql Interview Questions 205 2008 Performance Bala Murugan

SQL WHERE

Only when the SQL where clause condition is processed, the database will return a value from the table specified by filtering the entries (records in the table).

sql select where


ID BookName Price Year Domain AuthorName
1 Pro MySql Administration 136.33 2015 Database Hanumanthan
2 A Visual Introduction To Sql 80 2008 Administration Rishi Keshan
3 Microsoft SQL Server 2012 Bible 100 2011 Database Sakunthala
4 Head First SQL 180 2010 Administration Ramanathan

Posted by at No comments:

SQL TUTORIAL - PART 4

SQL TUTORIAL - PART 4

SQL ALIAS

An alias is a feature of SQL that is supported by most, if not all, relational database management systems (RDBMSs). Aliases provide database administrators to understand easily.

table alias sql


ID BookName Price Year Domain AuthorName
1 Microsoft SQL Server 2008 136.33 2010 Programming Azaghu Varshith
2 SQL Server 2008 Transact-Sql 165 2009 Programming Devi Mai
3 Mastering Oracle SQL 75 2012 Performance Balan
4 Red Gate Guide to SQL Server 99.99 2009 Security Nirmala

SQL ALTER TABLE

This topic describes how to add new columns to a table in SQL Server 2016 by using SQL Server. For more information, see ALTER TABLE (Transact-SQL).

alter table rename column


ID BookName Price Year Domain AuthorName
1 Data Analysis Using SQL 105 2014 Security Hanumanthan
2 SQL Made Simple... By Examples 65 2011 Optimization Vinoth Kumar
3 Pro Oracle Administration 170 2009 Security Padmavathi
4 Database Systems Using Oracle 155 2014 Database Padmavathi

SQL AND OR

This SQL tutorial explains how to use the AND condition and the OR condition together in a single query with syntax and examples.

database and sql


ID BookName Price Year Domain AuthorName
1 Oracle Fundamentals 175 2007 Administration Balan
2 My SQL Complete Reference 80 2014 Administration Geetha
3 The Complete Guide to Oracle 155 2008 Optimization Vinoth Kumar
4 Teach Yourself SQL 168.27 2014 Programming Harish Karthik

SQL AUTO INCREMENT

You can retrieve the most recent automatically generated AUTO-INCREMENT value with the LAST-INSERT-ID() SQL function or the mysql-insert-id() C API.

sql auto-increment


ID BookName Price Year Domain AuthorName
1 Jump Start MySQL 140 2013 Programming Dharan
2 MySQL Cookbook 168.27 2013 Administration Hanumanthan
3 SQL For Microsoft Access 100 2010 Programming Keshavan
4 Teach Yourself SQL 80 2012 Programming Dharan

SQL BETWEEN

If the BETWEEN expression appears in PL/SQL, expr1 is guaranteed to be evaluated only once. The boolean operator AND may produce unexpected results.

between dates sql


ID BookName Price Year Domain AuthorName
1 SQL Puzzles & Answers 84.22 2006 Performance Bala Murugan
2 Oracle Query Performance Tuning 100 2010 Security Azaghu Varshith
3 Pro MySql Administration 200 2007 Database Geetha
4 SQL Visual Quickstart 165 2009 Optimization Vinoth Kumar

SQL CHECK

This SQL Server tutorial explains how to use the check constraints in SQL Server (Transact-SQL) with syntax and examples.

check constraint


ID BookName Price Year Domain AuthorName
1 Mastering Oracle SQL 120 2014 Administration Varshini Kutty
2 SQL Server Database Internals 125 2009 Performance Ramanathan
3 Troubleshooting MYSQL 130 2015 Database Vinoth Kumar
4 Microsoft SQL Server 2012 168.27 2012 Database Azaghu Varshith

SQL CREATE TABLE

This SQL Server tutorial explains how to use the CREATE TABLE statement in SQL Server (Transact-SQL) with syntax and examples.

how to create a table in sql


ID BookName Price Year Domain AuthorName
1 From Access To SQL Server 180 2012 Optimization Keshavan
2 SQL Server 2008 Transact-Sql 175 2008 Programming Varshini Kutty
3 Sql Server Concurrency 150 2011 Optimization Nirmala
4 MySql Interview Questions 199.97 2008 Performance Bala Murugan

SQL DEFAULT

The DEFAULT constraint provides a default value to a column when the INSERT record does not contain a value for specified column.

alter table alter column default


ID BookName Price Year Domain AuthorName
1 Programming With Oracle 60 2015 Database Pandurengan
2 SQL Visual Quickstart 115 2006 Database Varshini Kutty
3 Pro SQL Azure 130 2013 Performance Hari Krishnan
4 Natural language Query To SQL 155 2011 Performance Hanumanthan

SQL DELETE

In the database structured query language (SQL), the DELETE statement removes one or more records from a table. A subset may be defined for deletion using a condition, otherwise all records are removed.

delete statement in sql


ID BookName Price Year Domain AuthorName
1 Complete Guide To No-SQL 84.22 2011 Database Rishi Keshan
2 Oracle Concurrency 136.33 2012 Performance Dharan
3 From Access To SQL Server 140 2006 Optimization Harish Karthik
4 Oracle: The Complete Reference 195 2011 Security Hari Krishnan

SQL DISTINCT

The DISTINCT clause in your result set will listed after the DISTINCT keyword, and therefore returns unique combinations.

mssql distinct


ID BookName Price Year Domain AuthorName
1 The Database Language SQL 150 2010 Security Siva Kumar
2 The Gurus Guide To SQL Server 165 2006 Security Harish Karthik
3 SQL Server 2008 Transact-Sql 160 2011 Security Vinoth Kumar
4 The Complete Guide to MySql 130 2015 Administration Bala Murugan

SQL FOREIGN KEY

This SQL Server tutorial explains how to use Foreign Keys in SQL Server with syntax and examples. A foreign key is a way to enforce referential integrity within table.

foreign key in dbms


ID BookName Price Year Domain AuthorName
1 SQL Server Fundamentals 178.69 2014 Administration Harish Karthik
2 The Complete Guide to Oracle 105 2015 Programming Azaghu Varshith
3 The Complete Guide to SQL Server 140 2013 Security Vinoth Kumar
4 Troubleshooting MYSQL 160 2014 Performance Sakunthala

SQL FULL JOIN

The SQL FULL JOIN statement with syntax and examples.

sql full


ID BookName Price Year Domain AuthorName
1 Practical SQL 60 2011 Administration Balan
2 MySQL Cookbook 71.87 2008 Programming Harish Karthik
3 Oracle: The Complete Reference 65 2009 Programming Siva Kumar
4 MySql Concurrency 84.22 2015 Performance Vinoth Kumar

SQL FUNCTION ABS

In SQL Server (Transact-SQL), the ABS function returns the absolute value of a number.

sql absolute value


ID BookName Price Year Domain AuthorName
1 Simply SQL 199.97 2006 Security Vinoth Kumar
2 SQL Server 2012 Black Book 160 2013 Database Siva Kumar
3 SQL in Easy Steps 115 2014 Optimization Vidyavathi
4 SQL For Microsoft Access 155 2014 Performance Sakunthala

SQL FUNCTION AVG

Applies the aggregate function to all values. ALL is the default. DISTINCT Specifies that AVG be performed only on each unique instance of a value.

tsql average


ID BookName Price Year Domain AuthorName
1 Red Gate Guide to SQL Server 115 2010 Administration Bala Murugan
2 Oracle Interview Questions 100 2011 Optimization Siva Kumar
3 Oracle Database 11G New Features 71.87 2010 Performance Dharan
4 Easy Oracle PL/SQL Programming 160 2014 Administration Siva Kumar

SQL FUNCTION CEILING

This Oracle tutorial explains how to use the Oracle / PLSQL CEIL function with syntax and examples.

ceiling sql server


ID BookName Price Year Domain AuthorName
1 Sql Server Cookbook 195 2013 Administration Hanumanthan
2 MySql Database Internals 145 2013 Optimization Hari Krishnan
3 Pro MySql Administration 190 2012 Performance Keshavan
4 Simply SQL 80 2010 Performance Ranjani Mai

SQL FUNCTION CHARINDEX

In SQL Server, you can use CHARINDEX function that allows you to specify the start position, but not the occurrence, or you can use a user-defined function.

sql charindex


ID BookName Price Year Domain AuthorName
1 Transact SQL Cookbook 123.45 2010 Performance Pandurengan
2 Oracle: The Complete Reference 175 2013 Performance Siva Kumar
3 MySql Fundamentals 145 2008 Administration Harish Karthik
4 Getting Started With SQL 135 2013 Security Vidyavathi

SQL FUNCTION CONCAT

The 1Keydata SQL Tutorial teaches beginners the building blocks of SQL. This section explains the Concatenate function.

concat sql


ID BookName Price Year Domain AuthorName
1 A Visual Introduction To Sql 199.97 2012 Optimization Hari Krishnan
2 Sql Server T-sql By Example 95 2014 Security Hari Krishnan
3 SQL Visual Quickstart 200 2014 Programming Azaghu Varshith
4 My SQL Complete Reference 185 2015 Database Hari Krishnan

SQL FUNCTION COUNT

SQL SELECT DISTINCT with COUNT on ROWS or on one columns.

select count


ID BookName Price Year Domain AuthorName
1 Oracle 11g PL/SQL Programming 115 2015 Database Rishi Keshan
2 SQL For Microsoft Access 95 2006 Database Devi Mai
3 Simply SQL 80 2012 Security Pandurengan
4 SQL Server 2012 Black Book 185 2008 Security Bala Murugan

SQL FUNCTION DATEADD

In Access, the DateAdd function Adds a specified time interval to a date.

sql server dateadd


ID BookName Price Year Domain AuthorName
1 Oracle Interview Questions 185 2008 Programming Azaghu Varshith
2 SQL Server 2012 Black Book 165 2011 Database Sakunthala
3 Learing Sql Server T-Sql 155 2008 Database Varshini Kutty
4 Natural language Query To SQL 178.69 2010 Programming Hanumanthan

SQL FUNCTION DATEDIFF

The 1Keydata SQL Tutorial teaches beginners the building blocks of SQL. This section explains the DATEDIFF function.

sql server datediff


ID BookName Price Year Domain AuthorName
1 Head First SQL 65 2011 Programming Hanumanthan
2 Oracle Interview Questions 110 2010 Optimization Vinoth Kumar
3 Understanding the New SQL 130 2010 Optimization Devi Mai
4 Sql Server Interview Questions 190 2008 Programming Nirmala

SQL FUNCTION DATEPARTS

The 1Keydata SQL Tutorial teaches beginners the building blocks of SQL. This section explains the DATEPART function.

sql server datepart


ID BookName Price Year Domain AuthorName
1 MySql Fundamentals 105 2008 Database Hari Krishnan
2 Introduction to SQL and PL/SQL 195 2015 Database Dharan
3 MySql for professionals 60 2014 Administration Balan
4 Red Gate Guide to SQL Server 125 2012 Security Geetha

SQL FUNCTION FLOOR

The FLOOR function returns the largest integer less than or equal to the ... Using Mathematical Functions (Transact-SQL) Comparing CEILING and FLOOR.

sql server floor


ID BookName Price Year Domain AuthorName
1 SQL Design Patterns 165 2011 Security Vinoth Kumar
2 Oracle: The Complete Reference 185 2011 Performance Sakunthala
3 SQL Server All-in-One For Dummies 136.33 2008 Performance Hanumanthan
4 Troubleshooting Oracle 190 2007 Database Varshini Kutty

SQL FUNCTION MAX

SQL MAX function is used to find out the record with maximum value among a record set.

max in sql


ID BookName Price Year Domain AuthorName
1 Oracle All-in-One For Dummies 150 2007 Programming Ranjani Mai
2 Practical SQL 75 2010 Programming Vidyavathi
3 SQL Server Database Internals 95 2009 Security Dharan
4 Oracle Database 11G New Features 100 2012 Programming Hari Krishnan

SQL FUNCTION MID

The MID() function is used to extract values from a column. The MID() contain three (3) parameters.

mid sql


ID BookName Price Year Domain AuthorName
1 Teach Yourself SQL in 10 Minutes 123.45 2010 Security Padmavathi
2 Oracle Database Internals 199.97 2015 Security Ramanathan
3 Art Of SQL 99.99 2009 Programming Keshavan
4 SQL Design Patterns 125 2010 Performance Vinoth Kumar

SQL FUNCTION MIN

This SQL Server tutorial explains how to use the MIN function in SQL Server (Transact-SQL) with syntax and examples.

sql min


ID BookName Price Year Domain AuthorName
1 SQL All-in-One For Dummies 168.27 2007 Security Sakunthala
2 The Microsoft Data Warehouse 180 2008 Security Geetha
3 Securing MySql 135 2015 Database Keshavan
4 Mastering Oracle SQL 136.33 2007 Database Ramanathan

SQL FUNCTION NOW

The function requires no arguments. In distributed SQL statements, this function returns the date and time set for the operating system of your local database.

mssql now


ID BookName Price Year Domain AuthorName
1 Simply MySql 125 2010 Administration Dharan
2 Oracle Query Performance Tuning 120 2006 Programming Geetha
3 How to Write Accurate SQL Code 110 2007 Database Padmavathi
4 Oracle Database 11G New Features 145 2010 Database Rishi Keshan

SQL FUNCTION RAND

The RAND function returns a random floating-point value between 0 and 1. An argument can be specified as an optional seed value.

sql random


ID BookName Price Year Domain AuthorName
1 Jump Start MySQL 195 2013 Administration Varshini Kutty
2 Pro Oracle SQL 65 2015 Database Ramanathan
3 Teach Yourself SQL 90 2009 Optimization Balan
4 The Database Language SQL 70 2012 Programming Devi Mai

SQL FUNCTION REPLACE

The 1Keydata SQL Tutorial teaches beginners the building blocks of SQL. This section explains the REPLACE function.

replace sql server


ID BookName Price Year Domain AuthorName
1 Simply SQL 136.33 2010 Administration Chandra
2 The SQL Programming Language 195 2008 Database Geetha
3 Oracle Cookbook 205 2015 Performance Chandra
4 SQL Server Fundamentals 170 2009 Administration Dharan

SQL FUNCTION ROUND

The SQL ROUND() function rounds a number to a precision.

round function


ID BookName Price Year Domain AuthorName
1 Microsoft SQL Server 2012 Bible 60 2012 Performance Nirmala
2 Oracle Interview Questions 115 2009 Administration Balan
3 MySql Fundamentals 75 2011 Security Pandurengan
4 PHP And MySQL Bible 178.69 2011 Programming Keshavan

SQL FUNCTION SQRT

This Oracle tutorial explains how to use the Oracle / PLSQL SQRT function with syntax and examples.

sqrt sql


ID BookName Price Year Domain AuthorName
1 Troubleshooting Oracle 130 2006 Optimization Siva Kumar
2 MySql Concurrency 168.27 2008 Security Chandra
3 Access 2010 Pure Sql 71.87 2013 Security Geetha
4 The Database Language SQL 140 2014 Programming Nirmala

SQL FUNCTION SUM

Syntax for SQL Server and Azure SQL Database SUM ( [ ALL | DISTINCT ] ... The following examples shows using the SUM function to return summary data.

sum in sql


ID BookName Price Year Domain AuthorName
1 Professional MySql 155 2008 Database Harish Karthik
2 SQL For Microsoft Access 160 2009 Database Keshavan
3 Simply MySql 105 2008 Database Ramanathan
4 Microsoft SQL Server 2012 Bible 60 2015 Performance Geetha

SQL GROUP BY

The GROUP BY clause will gather all of the rows together that contain data in the specified column(s) and will allow aggregate functions to be performed on the grouped data.

group by


ID BookName Price Year Domain AuthorName
1 SQL and Relational Theory 178.69 2011 Programming Ranjani Mai
2 From Access To SQL Server 105 2007 Optimization Padmavathi
3 Learing Sql Server T-Sql 80 2010 Database Nirmala
4 Microsoft SQL Server 2012 115 2008 Database Keshavan

SQL HAVING

The WHERE clause places conditions on the selected columns, whereas the HAVING clause places conditions on groups created by the GROUP BY clause.

having clause in sql


ID BookName Price Year Domain AuthorName
1 MySql for professionals 200 2010 Security Siva Kumar
2 Securing Oracle 115 2011 Administration Siva Kumar
3 Teach Yourself SQL in 10 Minutes 199.97 2011 Security Varshini Kutty
4 MySql Concurrency 85 2008 Performance Sakunthala

SQL IN

This SQL tutorial explains how to use the SQL IN condition with syntax and examples. The SQL IN condition (sometimes called the IN operator) allows you to select a value from a list.

sql in clause


ID BookName Price Year Domain AuthorName
1 Getting Started With SQL 70 2012 Programming Vinoth Kumar
2 MySql Concurrency 90 2009 Security Pandurengan
3 Professional Oracle 105 2012 Database Keshavan
4 SQL Server All-in-One For Dummies 200 2013 Performance Varshini Kutty

SQL INNER JOIN

An inner join is a join in which the values in the columns being joined are compared using a ... The following Transact-SQL query is an example of an inner join

sql update inner join


ID BookName Price Year Domain AuthorName
1 Understanding the New SQL 195 2009 Performance Sakunthala
2 Simply SQL 95 2006 Programming Vidyavathi
3 MySql Query Performance Tuning 90 2010 Administration Sakunthala
4 MySql Database Internals 200 2006 Performance Keshavan

SQL INSERT INTO

For a full description of the INSERT statement, see Oracle Database SQL Reference. You can retrieve the column values into variables or into collections.

insert into table


ID BookName Price Year Domain AuthorName
1 MySQL Cookbook 75 2013 Optimization Rishi Keshan
2 SQL in Easy Steps 136.33 2015 Database Keshavan
3 SQL Server Database Internals 65 2012 Administration Vinoth Kumar
4 SQL Server 2012 Black Book 120 2008 Optimization Ramanathan

SQL INSERT INTO SELECT

INSERT INTO SQL Server table with SELECT command ... In some of our earlier examples we used the a SELECT statement to verify the results of the INSERT statement.

insert into select sql


ID BookName Price Year Domain AuthorName
1 MySql Interview Questions 60 2008 Optimization Vidyavathi
2 SQL Functions Reference 135 2013 Administration Pandurengan
3 SQL: The Complete Reference 175 2007 Optimization Keshavan
4 Mastering Oracle SQL 136.33 2014 Programming Padmavathi

SQL LEFT JOIN

MySQL implements an A LEFT JOIN B join-condition as follows: ... The LEFT JOIN condition is used to decide how to retrieve rows from table B . (In other words, any condition in the WHERE clause is not used.).

left join vs right join


ID BookName Price Year Domain AuthorName
1 A Visual Introduction To Sql 60 2009 Optimization Ramanathan
2 Professional Microsoft SQL Server 180 2011 Administration Vinoth Kumar
3 Securing Oracle 65 2014 Optimization Nirmala
4 Red Gate Guide to SQL Server 100 2006 Administration Devi Mai

SQL LIKE

Using wildcard characters makes the LIKE operator more flexible than using the = and ... If any one of the arguments is not of character string data type, the SQL.

like in sql


ID BookName Price Year Domain AuthorName
1 SQL Server All-in-One For Dummies 71.87 2011 Security Balan
2 Learing Sql Server T-Sql 123.45 2013 Security Hanumanthan
3 MySQL: The Complete Reference 75 2012 Database Dharan
4 Jump Start MySQL 205 2015 Performance Geetha

SQL NOT NULL

Oracle Database SQL Language Reference. open .... A primary key constraint combines a NOT NULL constraint and a unique constraint in a single declaration.

not null sql


ID BookName Price Year Domain AuthorName
1 My SQL Complete Reference 178.69 2007 Security Vinoth Kumar
2 MySql All-in-One For Dummies 135 2008 Database Varshini Kutty
3 SQL Server All-in-One For Dummies 165 2012 Performance Sakunthala
4 Introduction to SQL and PL/SQL 170 2012 Programming Dharan

SQL ORDER BY

SELECT returns records in no particular order. To ensure a specific order use the ORDER BY clause. ORDER BY allows sorting by one or more columns.

select order by


ID BookName Price Year Domain AuthorName
1 SQL Visual Quickstart 140 2006 Performance Vinoth Kumar
2 Pro Oracle SQL 75 2013 Performance Devi Mai
3 The Gurus Guide To SQL Server 110 2009 Performance Harish Karthik
4 Advanced SQL Programming 175 2010 Security Vidyavathi

SQL PRIMARY KEY

Learn how to create, change, drop, disable, and enable a primary key in SQL Server (Transact-SQL) with syntax and examples.

primary key vs unique key


ID BookName Price Year Domain AuthorName
1 Mastering Oracle SQL 125 2012 Performance Devi Mai
2 Programming With MySQL 105 2011 Performance Chandra
3 Professional Oracle 190 2006 Performance Hari Krishnan
4 Microsoft SQL Server 2008 165 2010 Database Bala Murugan

SQL RIGHT JOIN

A RIGHT OUTER JOIN is one of the JOIN operations that allow you to specify a JOIN clause. It preserves the unmatched rows from the second (right) table.

right outer join


ID BookName Price Year Domain AuthorName
1 Understanding the New SQL 71.87 2006 Performance Keshavan
2 Professional MySql 150 2014 Administration Devi Mai
3 SQL Server 2012 Black Book 205 2007 Security Varshini Kutty
4 Learing Sql Server T-Sql 178.69 2010 Security Padmavathi

SQL SELECT

The SELECT clause specifies a list of properties (columns) by name, or the wildcard character (“*”) to mean “all properties”. Notice the special case of join propname, this provides for joins, but only on the column, as Database View.

sql server select


ID BookName Price Year Domain AuthorName
1 Head First SQL 75 2009 Database Pandurengan
2 MySql Concurrency 70 2015 Programming Azaghu Varshith
3 SQL Visual Quickstart 85 2012 Database Sakunthala
4 MySql Query Performance Tuning 155 2006 Database Siva Kumar

SQL TOP

The SELECT TOP statement returns a specified number of records. SELECT TOP is useful when working with very large datasets.

oracle select top


ID BookName Price Year Domain AuthorName
1 Sql Server Interview Questions 105 2015 Optimization Dharan
2 MySQL: The Complete Reference 200 2008 Programming Bala Murugan
3 Simply SQL Server 190 2009 Optimization Devi Mai
4 The Microsoft Data Warehouse 90 2008 Administration Devi Mai

SQL UNION

The UNION operation is different from using joins that combine columns from two ... Syntax for SQL Server, Azure SQL Database, Azure SQL Data Warehouse.

oracle union


ID BookName Price Year Domain AuthorName
1 MySql Concurrency 135 2012 Performance Vidyavathi
2 Head First SQL Brain On SQL 145 2011 Programming Dharan
3 MySql All-in-One For Dummies 115 2015 Performance Ranjani Mai
4 SQL Server Database Internals 70 2015 Programming Keshavan

SQL UNIQUE

SQL UNIQUE constraint check column value must be unique across the given field in table. Primary key characteristics automatic include UNIQUE key constraint.

unique constraint


ID BookName Price Year Domain AuthorName
1 Teach Yourself SQL 125 2013 Database Balan
2 SQL Fundamentals 205 2008 Optimization Pandurengan
3 Oracle Database Internals 150 2012 Administration Dharan
4 Oracle Query Performance Tuning 170 2011 Administration Vidyavathi

SQL UPDATE

For the UPDATE to be successful, the user must have data manipulation privileges (UPDATE privilege) on the table or column and the updated value must not conflict with all the applicable constraints (such as primary keys, unique indexes, CHECK constraints, and NOT NULL constraints).

update query


ID BookName Price Year Domain AuthorName
1 SQL Server Database Internals 185 2014 Optimization Padmavathi
2 Oracle Cookbook 75 2014 Administration Bala Murugan
3 SQL Server 2008 Transact-Sql 165 2010 Programming Geetha
4 Troubleshooting SQL Server 130 2009 Programming Balan

SQL WHERE

WHERE is an SQL reserved word. SQL Where clause is basically used to fetch the data from a particular table or multiple tables by joining tables.

where clause in sql


ID BookName Price Year Domain AuthorName
1 Teach Yourself SQL 70 2009 Performance Hanumanthan
2 MySql for professionals 165 2015 Database Rishi Keshan
3 SQL Server 2008 Transact-Sql 135 2008 Security Vidyavathi
4 The SQL Programming Language 195 2011 Optimization Devi Mai

Posted by at No comments:
Subscribe to: Posts (Atom)