• Compare date in SQL
    08 October

    How to Compare Dates in SQL

    Agenda This article will look at yet another interesting topic in SQL commonly asked in interviews – How to Compare Dates or Date type date in SQL. We will look at different approaches with examples for a clear description. At first, let’s have a quick look at the Date data type in SQL. Introduction to […]

  • nvarchar vs varchar
    29 July

    nvarchar vs varchar in SQL Server

    This article will look at the difference between the data types NVARCHAR and VARCHAR in SQL. These data types are commonly used for storing textual data or strings for various design purposes. We will look at the description of each along with the best-case scenario to use each data type with practical examples. We will […]

  • Difference between Where and having clause in SQL
    30 June

    Difference between WHERE and HAVING clause in SQL

    In this article, we will look at the difference between the WHERE and HAVING Clause in SQL. This is an important question asked in Interviews so we will look at each Keyword in detail with sample queries and compare their differences. At first, let us look at the description of the WHERE and HAVING Clause. […]

  • Join 3 or more table in SQL
    05 April

    Join 3 or More Tables in SQL

    In this article, we will have a look at an important topic in SQL, how to perform Join when there are more than two tables given . Typically, Joins or JOIN Clauses are used to combine rows or records from two or more tables on the basis of a common or related column between them. […]

  • Find 2nd Highest Salary Employee in SQL
    22 March

    Find 2nd Highest Salary in SQL

    Learn about how to find 2nd highest salary in SQL.