SQL Exercise – 6
SQL Exercise: Suppose you have a Sales table that tracks product sales data, including the sale amount, product category, and sale date. You want to… Read More »SQL Exercise – 6
Home » SQL SERVER »
SQL SERVER
SQL Server Tutorials| Basics & Advance Concepts | Interview Question & Answer Series | SQL Server Tricks & Tips
SQL Exercise – 5
SQL Exercise: You have a Sales table that tracks product sales in different cities for various dates. Now, you have to get the following information.… Read More »SQL Exercise – 5
SQL Exercise – 4
SQL Exercise: Write Query to: Find all customers with the last name “Singh”. Retrieve customers whose email address contains the word “kumar”. Retrieve customers living… Read More »SQL Exercise – 4
SQL Exercise – 3
SQL Exercise: Write a query to find the top 3 cities by total sales revenue, including: The total revenue for each city. The number of… Read More »SQL Exercise – 3
SQL Exercise – 2
SQL Exercise: Write a query to find the following details for each department: The total hours worked by employees on all projects. The number of… Read More »SQL Exercise – 2
SQL Exercise – 1
Query: Write a query to find the name of each employee, their department name, their manager’s name, and the total budget of the projects their… Read More »SQL Exercise – 1
Compare the values of current row with previous row in SQL
Sometimes, we need to calculate the difference between the values of the current row and the previous row in a table or you can say… Read More »Compare the values of current row with previous row in SQL
Extract URL and display name from string
How would you extract the display name and URL from a string in the format [display_name](url)? For example: Let’s say for string [abc](https://www.sqlskull.com), how would… Read More »Extract URL and display name from string
Find the numbers that appear at least three times consecutively
This is one of the most asked SQL interview question find the the numbers that appear at least three times consecutively. As, you can see… Read More »Find the numbers that appear at least three times consecutively
Find department top 3 salaries
Write a SQL query to find a top 3 highest paid employees in each of the department. As you , here we have two tables… Read More »Find department top 3 salaries
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
Find a managers with at least 3 direct reports
SQL query to find manager who have at least 3 direct reports. Here, we have a sample table named Employee. Create table Employee (Id INT,… Read More »Find a managers with at least 3 direct reports
ACID properties in SQL Server
The ACID properties in SQL are a set of characteristics that ensure the reliability and consistency of transactions in a relational database. It is an… Read More »ACID properties in SQL Server
Concat function in Power Apps
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
Reset multiple controls or all controls on a form 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- 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
Create Filter Activity in Azure Data Factory
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
Create a Schedule Trigger 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 DDL, DML, DCL and TCL commands
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
Difference between union and union all
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