Basic SQL Advanced SQL Tutorials

Tutorials Shared by the Internet Community

Advertisements

  Top Tutorials     New Tutorials     Submit     Login     Register  


Found 5 Tutorials

gap line

Most Recent Tutorials


  • 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
    • 25702 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • 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...
    • 19493 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • 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
    • 23419 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

  • 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
    • 18408 Hits
    • RatingTutorials RatingTutorials RatingTutorials RatingTutorials RatingTutorials Rating

« PreviousNext »


Advertisements