Home

Structure Query Language (SQL) Tutorials, Articles

Latest Articles, Tutorials, Examples on SQL

1. Introduction to Structure Query Language (SQL)
2. SQL Comments
3. SQL Data Types
4. SQL Transactions
5. Transactions (Properties and Control Commands) in SQL
6. What are the clause, Keywords and statement in SQL?
7. SQL | DDL, DML, TCL, and DCL Commands
8. SQL - CREATE Command (to create Database and Table)
9. SQL - SELECT Command (to retrieve data from table/view)
10. SQL - DELETE Statement (to delete records/table)
11. Difference between Delete and Truncate Command in SQL
12. Difference between Drop and Truncate Command in SQL
13. SQL - INSERT INTO Statement (to insert/add record into table)
14. SQL - UPDATE Statement (to update record in table)
15. SQL - ALTER TABLE statement (to modify table definition)
16. SQL - WHERE Clause (to filter data)
17. SQL - VIEW AND DUAL
18. SQL - GROUP BY and ORDER BY
19. SQL - HAVING Clause
20. SQL INDEX - To speedup data retrieval operations
21. Transactions (Properties and Control Commands) in SQL
22. SQL - Explain VIEW with Examples
23. Wildcard Operators in SQL
24. Wildcards Examples in SQL
25. Implement CREATE VIEW in SQL
26. How to use UNION in SQL?
27. Temporary tables in SQL
28. How can we use Sub Queries in SQL?
29. Clone data between tables in SQL
30. How to handle duplicate data in SQL?
31. Alterations on table in SQL
32. Using TRUNCATE TABLE in SQL
33. Sort resultSet using ORDER BY clause in SQL
34. SQL query to find duplicate records
35. SQL query to join two tables
36. SQL query to delete duplicate records
37. SQL query to change column name
38. SQL query to add values in column
39. SQL query to add primary key
40. SQL Query to alter column size
41. SQL Query to auto increment primary key
42. SQL Query to avoid duplicate records
43. SQL Query to access first and last N records from a table
44. SQL Clauses
45. Transaction Control Language (TCL) commands in SQL
46. SQL Alias
47. Difference between WHERE and HAVING clauses in SQL
48. SQL Joins Tutorial with Queries and Examples
49. How to use AND/ OR Operator in SQL?
50. Use of Injection in SQL
51. SELECT TOP with Example in SQL
52. IN Operator with Example in SQL
53. How to use Foreign Key in SQL?
54. Use of CHECK Constraint in SQL
55. Use of DEFAULT Constraint in SQL

SQL Functions

1. NULL VALUES and NULL FUNCTIONS in SQL
2. Use of LEN(), ROUND() functions in SQL
3. Use of DATES and its different built-in functions NOW(), FORMAT() in SQL
4. Use of UCASE(), LCASE() and MID() functions in 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