Tutorial Gateway

  • C
  • C#
  • Java
  • Python
  • SQL
  • MySQL
  • Js
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Python Programs
    • Java Programs
    • SQL FAQ’s

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

  • SQL DML, DDL, DCL & TCL Cmds
  • SQL NOT EXISTS Operator
  • SQL UPDATE from SELECT
  • SQL AFTER UPDATE Triggers
  • SQL Get Column Names in Table
  • SQL IF ELSE
  • SQL ACID Properties
  • SQL FOR XML PATH
  • Java Two Dimensional Array
  • Java Perfect Number Program
  • Java Count Digits in a Number
  • C Compare Two Strings Program
  • C Print Prime Numbers 1 to 100
  • C program to Reverse a String
  • C Palindrome Number Program
  • C Program for Palindrome String
  • C Remove Duplicate String Chars
  • C Square of a Number Program
  • C Sum and Average of N Number
  • Python Fibonacci Series program
  • Python Area Of Circle Program
  • Python Prime Numbers 1 to 100
  • Python Program for Leap Year
  • Tableau Rank Calculation
  • Tableau Google Maps usage
  • Power BI Format Dates
  • Power BI Top 10 Filters
  • Power BI – Create Hierarchy
  • Power BI DAX Math Functions
  • Learn SSIS in 28 Days
  • SSIS Transformations
  • SSIS Incremental Load
  • SSRS Drill Through Reports
  • SSRS Drill Down Reports
  • R Programming Tutorial
  • C Tutorial
  • C# Tutorial
  • Java Tutorial
  • JavaScript Tutorial
  • Python Tutorial
  • MySQL Tutorial
  • SQL Server Tutorial
  • R Tutorial
  • Power BI Tutorial
  • Tableau Tutorial
  • SSIS Tutorial
  • SSRS Tutorial
  • Informatica Tutorial
  • Talend Tutorial
  • C Programs
  • C++ Programs
  • Java Programs
  • Python Programs
  • MDX Tutorial
  • SSAS Tutorial
  • QlikView Tutorial

Copyright © 2021 | Tutorial Gateway· All Rights Reserved by Suresh

Home | About Us | Contact Us | Privacy Policy