Display employees and their manger name in SQL
This is one of the most asked SQL interview Question that write a SQL Query to display Employees and Manager name of the employee. Let’s… Read More »Display employees and their manger name in SQL
Home ยป
SQL Tutorial
This website provides a SQL Tutorial, SSRS, Power BI, Python, Azure basics and advanced tutorials for beginners and professionals
You will find out a step-by-step walk through of the basics and advanced topics with practical and include numerous hands-on activities.
SQL NOT EXISTS
The SQL NOT EXISTS Operator is used to check the existence of any record in a subquery. The NOT EXISTS operator returns true if the… Read More »SQL NOT EXISTS
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
How to get top salary of each department
To find the highest salary of employee in each department, first we will create a sample tables named EmployeeDetails and Department as shown below. CREATE… Read More »How to get top salary of each department
How to get the size of table in SQL
There are multiple ways to get the size of table in SQL Server. Lets take a look on them one by one. Using sp_spaceused system… Read More »How to get the size of table in SQL
Insert same rows multiple times in table
Sometimes you need to insert same row multiple times in a table. There are many ways to do that but here we will see one… Read More »Insert same rows multiple times in table
How to compare column names in two tables in SQL
In this article you will see how to compare column names in two table. Assume that, you have two tables and you are asked to… Read More »How to compare column names in two tables in SQL
Lost update problem in concurrent transations
A lost update problem occurs in concurrent transactions, when two transactions try to read and update the same column on the same row within a… Read More »Lost update problem in concurrent transations
SQL Return
SQL Return is a control-of-flow language keyword which is used to exit unconditionally from a query or stored procedure. It can be used at any… Read More »SQL Return
Add a Bookmarks to a report in SSRS
This article demonstrate how to add a bookmarks to a report in SSRS. Bookmark allows us to to navigate from one part of report to… Read More »Add a Bookmarks to a report in SSRS
Join two datasets in SSRS
This article demonstrate, how to join two datasets in SSRS. Assume that you have two different data sets, lets say one data set fetches the… Read More »Join two datasets in SSRS
Display a fixed number of rows per page in SSRS
This article demonstrate how to display a fixed number of rows per page in SSRS. Lets see step by step implementation of how to fix… Read More »Display a fixed number of rows per page in SSRS
Create Multi Group Drill Down Report in SSRS
This article demonstrate how to create a multi group drill down report, means drill down report on nested grouping. Lets see the step by step… Read More »Create Multi Group Drill Down Report in SSRS
Create Drill Down Group report in SSRS
This article demonstrate how to create a Drill Down group report in SSRS. In general, a drill down report allows users to click on plus… Read More »Create Drill Down Group report in SSRS
Create an Embedded Data set in SSRS
An embedded dataset is defined in and used by only the report it is embedded in. It can be used when you want to get… Read More »Create an Embedded Data set in SSRS
Create an Embedded Data Source in SSRS
An Embedded data source, also known as a report-specific data source is a data connection that is saved in the report definition, and embedded data… Read More »Create an Embedded Data Source in SSRS
Add Row Number for grouped data
This article demonstrate how to add a row number for grouped data in SSRS report. Means separate the row counts based on grouping. Suppose for… Read More »Add Row Number for grouped data
Show No Data found message when no row returned in SSRS
This article demonstrate how to display a message when no row or data found for user selection in SSRS report. Lets see step by step… Read More »Show No Data found message when no row returned in SSRS
Add row number in SSRS report
This article demonstrate how to add a row number, or serial number or you can say a Row number column in existing SSRS report. Although… Read More »Add row number in SSRS report
Alternate row colors in SSRS
This article demonstrate how to set alternate row background colors for SSRS table report. As you can see, here we have a sample report name… Read More »Alternate row colors in SSRS