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
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
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 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...
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
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
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
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