SQL Tutorials

INDEX: SQL Tutorial

SQL RIGHT JOIN

Types of SQL JOIN We have already discussed the topics- SQL JOIN and SQL INNER JOIN ,SQL LEFT JOIN . SQL RIGHT JOIN is very much similar to its counterpart.ALL the variety of joins can be easily explained with the help of venn diagrams.In this article we will understand the concept  by using examples and demo tables. The SQL …

SQL RIGHT JOIN Read More »

INDEX: SQL Tutorial

SQL operators

What is an operator? We will discuss about the various SQL operators , and use of it. But , before learning SQL operators , we ought to know about the basic of operators.An operator, in computer programming, is a symbol that usually represents an action or process.  Expression is incomplete without an operator.operator works as …

SQL operators Read More »

INDEX: SQL Tutorial

SQL LIMIT Clause

SQL LIMIT/TOP/ROWNUM Clause Structure Query Language  is a procedural programming language and provides us with many features. SQL LIMIT Clause has different names for different versions of SQL on different platforms. This clause is used to specify the number of records to return. NOTE[#1]: MS Access/ SQL Server SELECT TOP number|percent column_name(s) FROM table_name WHERE …

SQL LIMIT Clause Read More »