SQL interview Question and Answer

Find a largest single number in a table

Write a SQL query to find a largest single number in a table where single number is a number that appeared only once in the… Read More »Find a largest single number in a table

HackerRank SQL interview Question- Occupations

HackerRank SQL Interview Question: Level Medium Source: HackerRank Pivot the Occupation column in OCCUPATIONS so that each Name is sorted alphabetically and displayed underneath its corresponding Occupation. The output column headers… Read More »HackerRank SQL interview Question- Occupations

SQL LeetCode Rank Scores Problem

SQL LeetCode problem: Rank Scores Source: LeetCode Write an SQL query to rank the scores. The ranking should be calculated according to the following rules:… Read More »SQL LeetCode Rank Scores Problem

How to get multiple rows data in single row in SQL

This article demonstrates how to Convert multiple rows into a single comma separated row, it can be done by using in-built SQL functions. As you… Read More »How to get multiple rows data in single row in SQL

SQL Delete TOP

by Pradeep Raturi
SQL Basics, SQL SERVER

SQL delete statement is used to delete records from table based on specific conditions which are specified in where clause. Delete statement can also be… Read More »SQL Delete TOP

Get Row Counts for all tables in SQL Server

Sometime you are required to validate the row counts for each tables in database. So getting a row counts for each tables either through using… Read More »Get Row Counts for all tables in SQL Server

SQL Server Cross Apply and Outer Apply

by Pradeep Raturi
SQL Basics, SQL SERVER

SQL Server Cross Apply and Outer Apply

SQL Server APPLY operator is like a SQL JOINS, which allows joining two table expressions, but the Difference between APPLY operator and JOINS is the ability of APPLY operator to work with table- valued expression.