SQL Server Tutorials| Basics & Advance Concepts | Interview Question & Answer Series | SQL Server Tricks & Tips
The Concat function concatenates the result of a formula applied across all the records of a table and returns a single string. Concat( Table, Formula, separator) Table – Required. Table to… Read More »Concat function in Power Apps
Power Apps provides built-in functions such as Reset and ResetForm. Reset function allows you to reset a control to its Default property value while ResetForm allows… Read More »Reset multiple controls or all controls on a form in Power Apps
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
Filter activity is used in a pipeline to apply a filter expression to an input array, it filters an input data so that subsequent activities… Read More »Create Filter Activity in Azure Data Factory
Schedule trigger allows you to schedule a pipeline to run periodically (hourly, minutely, daily, weekly and monthly). When creating a schedule trigger, you can specify… Read More »Create a Schedule Trigger in azure data factory
SQL (Structured Query Language) is a programming language, It is used for managing and manipulating relational databases using various command such as DDL (Data Definition… Read More »SQL DDL, DML, DCL and TCL commands
The major difference between the UNION and UNION ALL operators in SQL is how they handle duplicate rows when the result set of multiple select… Read More »Difference between union and union all
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
A series of SQL most asked interview questions and answers for freshers and experienced professionals will help you prepare and cracking SQL interview. LeetCode –… Read More »SQL Interview Questions
An identity column in table generates key values automatically based on the current seed and increment, and the benefit of creating an identity column is… Read More »Reset Identity column value
This article demonstrate how to replace multiple columns value at once in Power Query. Lets say, you need to check if column value is blank… Read More »Replace multiple columns values in Power Query
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
Write an SQL query to report the nth highest salary from the Employee table. If there is no nth highest salary, the query should report null. Source:… Read More »SQL Leet Code Nth Highest Salary 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
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
Rolling average is a calculation to analyze data by creating series of average of different subsets of the entire data. For example, you have data… Read More »Rolling average in SQL
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
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
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
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