Basic SQL Tutorials

Tutorials Shared by the Internet Community

Advertisements

  Top Tutorials     New Tutorials     Submit     Login     Register  


Found 36 Tutorials

gap line

Most Recent Tutorials


  • Having vs where clause in sql

    This tutorial explains differences between Having and where clause in sql.Where clause is used with update,select,delete but Having clause is used onl
    http://java-interview-questions.com/difference-between-having-and-where-clause-sql-with-ex...
    • 3965 Hits
    • RatingURL RatingURL RatingURL RatingURL RatingURL Rating
    • Cat:Misc

  • How to create update and delete columns in SQL

    One of the three main task you in SQL is creating, updating and deleting columns of tables. This tutorial explains how to create, update and delete co
    http://javarevisited.blogspot.com/2012/12/sql-query-to-add-modify-and-drop-column-not-null...
  • A Brief History of SQL

    Prior to the release of the first relational database management system each database had a unique physical structure
    http://www.w3computing.com/sqlserver/brief-history-sql/
  • SQL query to find second Maximum Salary from Table

    How to find 2nd maximum, 3rd maximum or Nth maximum salary or Employee is a classical SQL Interview question. There are many ways to find Nth highest
    http://javarevisited.blogspot.com/2012/12/how-to-find-second-highest-or-maximum-salary-sql.html
  • SQL command to copy table with data

    It is a good decision to take backup of a table before doing any modification or inserting data on that table. In this article, we will learn a SQL co
    http://javarevisited.blogspot.com/2012/12/sql-query-to-copy-duplicate-or-backup.html
  • How to find duplicate rows in a table in MySQL and Orac

    Many times, we need to find out duplicate records in a table. This article shares couple of SQL queries, which we can use to find duplicate rows. thes
    http://javarevisited.blogspot.com/2012/12/how-to-find-duplicate-records-in-table-mysql-que...
  • Inner Join of three tables in SQL MySQL Oracle Server

    INNER JOIN is used to fetch data from multiple tables in one query, it helps to save database round trips, but getting data from more than two tables
    http://javarevisited.blogspot.com/2012/11/how-to-join-three-tables-in-sql-query-mysql-sqls...
  • Attach MDF file to the SQL database without LDF file

    Attaching .mdf file to the SQL database without .ldf file is a easy task but need attention. No matter SQL server shutdown properly or not.
    http://sqldbfriend.blogspot.in/2013/02/need-to-attach-mdf-file-without.html
    • 20131 Hits
    • RatingURL RatingURL RatingURL RatingURL RatingURL Rating
    • Cat:Misc

  • Correlated vs Noncorrelated Subquery example in SQL

    Main difference between Correlated and Noncorrelated subquery is that, Correlated subquery depends upon Outer query and can not execute by its own whi
    http://javarevisited.blogspot.com/2012/07/subquery-example-in-sql-correlated-vs.html
  • Dependencies: Partial and Transitive

    Description of Dependencies which violate normalization rules.
    http://www.webanswers.com/misc/what-is-the-difference-between-partial-dependency-and-trans...
    • 36147 Hits
    • RatingURL RatingURL RatingURL RatingURL RatingURL Rating
    • Cat:Misc

  • SQL SELECT Command Queries and Example for Beginners

    This Select command tutorial is good for every sql programmer both for advanced programmers and beginners and acts as refresher for many of us which
    http://javarevisited.blogspot.com/2011/10/selct-command-sql-query-example.html
    • 19580 Hits
    • RatingURL RatingURL RatingURL RatingURL RatingURL Rating
    • Cat:

  • Dont delete truncate your tables in SQL

    Dont Delete , truncate it. If you are working in a huge table you need to be very very careful while executing any query because due to large data an
    http://javarevisited.blogspot.com/2011/10/how-to-use-truncate-and-delete-command.html
  • Selecting Only Distinct Rows Or Entries From A Table

    The SELECT DISTINCT statement functions in much the same way as a standard select statement but will only return distinct column values.
    http://www.basewebmaster.com/sql/select-distinct.php
    • 19112 Hits
    • RatingURL RatingURL RatingURL RatingURL RatingURL Rating
    • Cat:

« Previous 1 2 Next »


Advertisements