C C++ Java Data Structure Python JavaScript CSS Ajax PL/SQL PHP Puzzles C programs C++ programs Java programs


Structure Query Language (SQL) Tutorials, Articles

Latest Articles, Tutorials, Examples on SQL

  1. Introduction to Structure Query Language (SQL).
    Learn: What is SQL (Structure Query Language)? what are the basic terminologies of SQL?
  2. 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.
  3. 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?
  4. 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?
  5. SQL - DELETE Statement (to delete records/table).
    SQL - DELETE command: Learn about the DELETE command, its syntax examples etc with queries.
  6. 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?
  7. Difference between Drop and Truncate Command in SQL.
    Learn: What is SQL - DROP command and SQL - TRUNCATE command? What are the differences between them?
  8. Find record of nth highest salary employee in SQL?
    Finding record of Nth highest salaried employee (where N, should equal to records or less then of the records), Here we are finding 1st , 2nd, 3rd and so on highest salaried employee’s name one by one using SQL Query.