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
Home » Archives for Pradeep Raturi »
Pradeep Raturi
I have 11+ years of working experience in Business Intelligence Data Modelling, Power BI, SQL Server, SSRS, SSIS, Azure Data Factory, Power Apps.
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
Switch function in Power Apps
The Power Apps Switch function evaluates a single condition against multiple possible matches. If a match is found, a corresponding value is returned. If no match… Read More »Switch function in Power Apps
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
Power Apps send email
Power Apps is a robust platform that allows you to create custom business applications with ease and efficiency. One of the most common and useful… Read More »Power Apps send email
Submit multiple records in Power Apps
In Power Apps, you can submit multiple records to a data source using different different approaches. It depends on your specific scenario. We will explore… Read More »Submit multiple records in Power Apps
Calendar and Clock functions in Power Apps
The Calendar and Clock functions are used to display dates and times in the language of the current user. Calendar and Clock functions return single-column tables that can be used… Read More »Calendar and Clock functions 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
ShowColumns function in Power Apps
The ShowColumns function creates a new table including all the columns that you specify and exclude all other columns. It does not modify the original table.… Read More »ShowColumns function in Power Apps
LookUp function in Power Apps
LookUp function in PowerApps allows you to find data from a related data source or table that satisfies the condition or formula given in the… Read More »LookUp function in Power Apps
Filter function in Power Apps
Power Apps Filter function allows you to find a records in a table that match the specific condition criteria. You can use more than one… Read More »Filter function in Power Apps
With function in Power Apps
The With function in Power Apps evaluates a formula for a single record. It improves the readability of complex formulas by dividing it into smaller… Read More »With function in Power Apps
Sequence function in Power Apps
The Sequence function in Power Apps generates a single column table of sequential numbers. The name of the column returned by Sequence function is Value.… Read More »Sequence function in Power Apps
Add alternate row color in gallery Power Apps
In Power Apps, to add alternating background colors to rows in a gallery, you need a sequential number (1, 2, 3, 4, 5, etc.), essentially… Read More »Add alternate row color in gallery Power Apps
Text function Power Apps
Power Apps Text function is used to convert any value and formats a number or date/time value to a string of text. Syntax: Text(Value, Format,… Read More »Text function Power Apps
Filter and search items in gallery Power Apps
A gallery control is used to show multiple records from a data source, and each record can contain multiple types of data. To filter the… Read More »Filter and search items in gallery Power Apps
Notify function in Power Apps
The Notify function displays a banner message to the user at the top of the screen. The character limit for Notify function is 500 characters, and the… Read More »Notify function in Power Apps