SQL SERVER Ranking Functions - RANK, DENSE_RANK, NTILE, ROW_NUMBER
SQL query to delete duplicate rows
SQL Server Isolation Levels with examples
SQL Server CTE(Common Table Expression) and Recursive Queries
CTE Recursive query for data hierarchy(Parent Child hierarchy)
Different methods of SQL queries to insert data in tables
SQL query to display all columns with datatypes for a given Table name
SQL query to check two tables have identical data
SQL query to search a string in database Schema
SQL query to display total number of rows for each table in database
SQL query to search a column name in all tables
SQL server query to search object name in database
SQL Server performance tip - Do not use NOT IN clause in Subquery use LEFT OUTER JOIN instead