SQL Interview Questions

This page is dedicated to SQL frequently asked questions, and SQL Interview Questions with answers. It is always advisable to learn SQL Sever, before looking into these questions.

SQL Interview Questions and SQL FAQ’s

Basic Connections and Configurations

1. Create ODBC Connection
2. Create ODBC Connection- Using Native Client
3. Connecting to R programming
4. Configure Database Mail
5. Create Native Client 11.0 Connection

Date and Time

1. Formatting DATE
2. Return Date Part Only from a Datetime datatype

Differences

1. Difference between DATEPART and DATENAME
2. Difference between UNION and UNION ALL
3. Differentiate among CTE, Temp Tables, Derived tables, Table Variables

Joins

1. Cross Join Vs Inner Join
2. List of Outer Joins

Groups

1. Count Records in a Group
2. Retrieve Last Record in each Group
3. Select Top N Records for each Category
4. Select First Row in each group

Select, Insert, Update, and Delete

1. Delete Duplicate Rows
2. Inserting values into Identity Column using IDENTITY INSERT
3. Insert Stored Procedure result into Temporary Table
4. Insert Images into Table
5. Select Rows with Maximum Value on a Column
6. UPDATE Table Columns from SELECT Statement

Strings

1. Concatenate Rows into String
2. Replace String in a Table Column
3. Reverse String Words
4. Extract Domain From Email

Tables and Columns

1. Get Column Names from Table
2. How to Swap Column Values
3. How to check if a Table exists
4. Identity Value Jumps after restarting
5. Find all Dependencies on Table
6. Find all Tables that Contain Specific Column Name
7. Rename Table Name, and Column Name

Misc

1. Calculating Running Total
2. Converting Rows into Columns without using PIVOT
3. Converting Column Names into Rows without using UNPIVOT
4. Export Data to CSV
5. Nth Highest Salary
6. Backup Database Automatically