Home

Structure Query Language (SQL) Tutorials, Articles

Latest Articles, Tutorials, Examples on SQL

1. SQL Joins Tutorial with Queries and Examples.
   SQL Join Tutorial - In this tutorial, we are going to learn about the SQL joins with Queries and Examples. There are two joins that we are going to discuss here - 1) Inner Join and 2) Outer Join and there sub parts.
2. Difference between WHERE and HAVING clauses in SQL.
   What are the differences between WHERE and HAVING clauses? Here, we are going to learn about what are the similarities and dissimilarities between HAVING and WHERE clauses in SQL?
3. SQL Alias.
   What is SQL alias? Here, we are going to learn how we can define aliases of table, column in SQL? What is the purposes of aliases and what is the advantages of SQL?
4. Transaction Control Language (TCL) commands in SQL.
   Learn: What are the Transaction Control Language (TCL) Commands in SQL? Here, we are going to learn about COMMIT, ROLLBACK, SAVEPOINT commands in SQL.
5. SQL Clauses.
   Define SQL clauses: Here, we are going to learn about where clauses, group by clauses, having clauses, order by clauses.
6. SQL Query to access first and last N records from a table.
   Here, we will learn how to access first and last N records from a table with an example of SQL Query that will return first and last N records from a table.
7. SQL Query to avoid duplicate records.
   In this article, we are going to learn about duplicate records and the process to avoid them in our ResultSet while selecting the data.
8. SQL Query to auto increment primary key.
   In this article, we are going to learn about the auto increment function of SQL and then the process to add it on our primary key.
9. SQL Query to alter column size.
   In this article, we are going to learn about the property of column and then we will alter the pre-defined size of column.
10. SQL query to add primary key.
    In this article, we are going to learn how to write a SQL Query to add primary key to a column?
11. SQL query to add values in column.
    In this article, we are going to learn a SQL query to add the values in the table columns.
12. SQL query to change column name.
    In this article, we are going to learn about the columns of the table and the process to change the name of the column.
13. SQL query to delete duplicate records.
    In this article, we are going to learn about duplicate records and the process to find and delete them from the database.
14. SQL query to join two tables.
    In this article, we are going to learn about SQL joins and going to join two tables with it, to get the whole data from both tables.
15. SQL query to find duplicate records.
    In this article, we are going to learn about to find duplicate records in database using SQL Query and then create 2 to 3 query to take out the duplicate record and resolve the problem.
16. Sort resultSet using ORDER BY clause in SQL.
    In this article, we are going to learn about the process of sorting data using ORDER BY clause in SQL.
17. Using TRUNCATE TABLE in SQL.
    In this article, we are going to learn about TRUNCATE TABLE to delete complete data from an existing table in SQL.
18. Alterations on table in SQL.
    In this article, we are going to learn about the alterations on the tables in SQL.
19. How to handle duplicate data in SQL?
    In this article, we are going to learn about the duplicate data and the process to handle it in SQL.
20. Clone data between tables in SQL.
    In this article, we are going to learn about the cloning of data between two different tables in SQL.
21. How can we use Sub Queries in SQL?
    In this article, we are going to learn about the sub queries and how they frequently used with the SELECT statement?
22. Temporary tables in SQL.
    In this article, we are going to learn about the temporary tables and the process to use it to store data temporarily.
23. How to use UNION in SQL?
    In this article, we are going to use UNION clause/operator which combine results of two or may be more than two SELECT statements.
24. Implement CREATE VIEW in SQL.
    In this article, we are going to use CREATE VIEW, basically view can be created from a single, multiple tables or we can use another view.
25. Wildcards Examples in SQL.
    In this article, we are going to use wildcards like (_, %) to manipulate resultSet came out from query.
26. Wildcard Operators in SQL.
    In this article, we are going to learn Wildcard operators in SQL (Structure Query Language). Learn how to use wildcard operator in SQL Query?
27. SQL - Explain VIEW with Examples.
    In this article, we are going to learn about the VIEW in SQL (DBMS), what is VIEW? How and why it is created? We will learn all about VIEW with syntax, and query examples.
28. Transactions (Properties and Control Commands) in SQL.
    In this article, we are going to learn about SQL transactions, its properties and its commands, which are known as Transaction control commands.
29. SQL INDEX - To speedup data retrieval operations.
    In this article, we are going to learn what is SQL INDEX, how to create and use INDEX in SQL? How it speeds up the data retrieval?
30. SQL - HAVING Clause.
    SQL - HAVING Clause: Here, we will learn how to use conditions on the groups formed by GROUP BY?
31. SQL - GROUP BY and ORDER BY.
    SQL - BROUP BY and ORDER BY: Here, we will learn how to form records on the basis of certain common elements and Order By to display them in an ascending and descending order.
32. SQL - VIEW AND DUAL.
    SQL - VIEW SQL - DUAL: Here, we will learn what is VIEW, how to create VIEW and how it reflects on the tables?
33. SQL - WHERE Clause (to filter data).
    SQL - WHERE Clause: Here, we will learn how to filter data from a table (it is used to check conditions).
34. SQL - ALTER TABLE statement (to modify table definition).
    SQL - ALTER TABLE statement: Here, we will learn how to modify a table’s definition like adding columns, removing columns, changing the data type size etc.
35. SQL - UPDATE Statement (to update record in table).
    SQL - UPDATE Statement: In this article, we are going to learn how to update a record using ‘UPDATE’ statement in SQL.
36. SQL - INSERT INTO Statement (to insert/add record into table).
    SQL - INSERT INTO statement: In this article, we are going to learn everything about ‘INSERT INTO’ statement in SQL with syntax and examples.
37. Difference between Drop and Truncate Command in SQL.
    Learn: What is SQL - DROP command and SQL - TRUNCATE command? What are the differences between them?
38. Difference between Delete and Truncate Command in SQL.
    Learn: What is SQL- Delete command and SQL – Truncate command? How to differentiate delete and truncate command in SQL, delete v/s truncate in SQL?
39. SQL - DELETE Statement (to delete records/table).
    SQL - DELETE command: Learn about the DELETE command, its syntax examples etc with queries.
40. SQL - SELECT Command (to retrieve data from table/view).
    Learn: How to get/fetch selected columns, rows of all columns, row of a table/view using SELECT query?
41. SQL - CREATE Command (to create Database and Table).
    SQL - CREATE Command: Here, we will learn how to create a database and a table using CREATE command in SQL?
42. What are the clause, Keywords and statement in SQL?
    Here, we will learn: what are the clauses, keywords and statements in SQL, in a query there are many words used and we have to know which is clause, keyword or statement? So let’s understand in this article.
43. Introduction to Structure Query Language (SQL).
    Learn: What is SQL (Structure Query Language)? what are the basic terminologies of SQL?

SQL Queries

• Find record of nth highest salary employee in SQL.
• SQL Query to find the Nth minimum Salary.
• SQL Query to fetch (print) Even and Odd records from a table.
• SQL Query to merge N columns as single column from a table.