Skip to content

Interview Sansar

Software jobs interview preparation source

  • Home
  • Interview Questions
    • C Interview Questions
    • C++ Advanced Interview Questions
    • C++ Basic Interview Questions
    • Core Java Interview Questions
    • Java Collections Interview Questions
    • Java Multithreading Interview Questions
    • C# Basic Interview Questions
    • C# Advanced Interview Questions
    • C# Multi-threading Interview Questions
  • MCQs
    • MCQ-C++
    • MCQ-Java
    • MCQ-SQL
    • MCQs Algorithms and Data Structure
  • Programming Examples
    • C Programming Examples
    • C++ Programming Examples
    • C# Programming Examples
    • SQL Examples
    • Oracle PL SQL Examples
    • Time Complexity
  • Blog
    • C++ interview questions
    • C# interview questions
    • Java Interview Questions
    • Short Interview Questions
    • Behavioural / HR Interview
  • You-Tube
  • About
    • Why Visit
    • Sitemap
    • Contact Us
    • e-author

Category: SQL

SQL tutorial ( Structured Query Language) with examples and notes.

SQL

SQL IN Operator

August 18, 2024January 29, 2023 rsingh

SQL IN operator is used to check if a value is present in a given list a result list returned by sub quarries. For example,

Read More
SQL

SQL MAX Function

August 18, 2024January 29, 2023 rsingh

SQL MAX() function is used to return maximum value from a column of a table using a SELECT statement in sql. SQL MAX function syntax

Read More
SQL

SQL MIN Function

August 18, 2024January 29, 2023 rsingh

SQL MIN() function is used to return minimum value from a column of a table using a SELECT statement. SQL MIN function syntax Syntax: SELECT

Read More
SQL

SQL SUM Function

August 18, 2024June 9, 2018 rsingh

SQL SUM Function with query example – Sum function returns sum of all values of a column or expression. SUM Function returns the sum value

Read More
SQL

SQL AVG Function

August 18, 2024June 10, 2018 rsingh

SQL AVG Function with query example – Avg function returns Average of all values of a column or expression. AVG function returns the average value

Read More
SQL

SQL DISTINCT

August 18, 2024January 29, 2023 rsingh

SQL Distinct statements with query example – Distinct statements in SQL is used to retrieve unique / different records from a column. It can return

Read More
SQL

SQL ORDER BY

August 18, 2024January 29, 2023 rsingh

SQL ORDER BY clause with query example – Order By clause is used to sort the data either in ascending order or in descending order

Read More
SQL

SQL GROUP BY

August 18, 2024January 29, 2023 rsingh

SQL GROUP BY clause with query example – Group By statement is used to group the common data in result set. For example,We have multiple

Read More
SQL

SQL HAVING Clause

August 18, 2024January 29, 2023 rsingh

SQL HAVING Clause –  Having clause is used to retrieve records on the basis of some condition. It is same like SQL WHERE Clause except

Read More
SQL

SQL Count – Count rows in SQL Table

August 18, 2024January 29, 2023 rsingh

SQL Count function with example – Count aggregate function returns total number of rows based on some condition like group by, distinct condition  and WHERE

Read More

Posts pagination

1 2 … 4 Next

My Unique Books for YOU

All Rights Reserved 2023: Interview Sansar.
Proudly powered by WordPress | Theme: Fairy Blog by Candid Themes.