Learn at Knowstar

SQL | Count(*) vs Count(1) Vs Count(colname) #sqltips

SQL Trick | How to find position of non Alphanumeric characters | PATINDEX #sqltips

SQL Query | How to find First and Last day of week | Date functions

SQL | Extract extension from filename | Extract last occurrence of substring | REVERSE

SQL Query | Split concatenated string into columns | STRING_SPLIT function

SQL Tutorial | Date Functions | Find Age from Birth Date

SQL Query | Split Concatenated String into Columns | CharIndex

SQL Trick | How to Sort NULLs Last |Custom Sorting #sqltips #sqlinterviewquestions

SQL Query | Custom Sorting | Order by Month in an Year

SQL Functions | Geography | Calculate Distance Using Latitude and Longitude coordinates

Power BI tutorial | Data Visualizations - Decomposition Tree

SQL Query | How to find employees hired in last n months | Datediff

SQL Tip | How to calculate Year To Date (YTD) and MTD Rolling totals | #sqlinterviewquestions

SQL | How to perform conditional / dynamic joins on multiple tables based on column value

SQL | Union Vs Union ALL | Which has better performance?

SQL Trick | Avoid this Most Common Programming Mistake ! Divide

SQL | ACE Your Next SQL Interview #sqltips #sqlinterviewquestions

SQL Tips | Generate Insert Script with Data #sqltips #sqlqueryinterviewquestionsandanswers

SQL Tricks | How to Identify Alphanumeric Values #sqltips

SQL Debugging | Common Programming Mistakes | Dates

SQL Tip | Find Table Constraint Name #sqltips

SQL Tricks | Find New, Active, Lapsed Customers | Customer LifeCycle #sqlinterviewquestions

SQL Query | How to dynamically convert rows into columns | Dynamic Pivot

SQL Tip | Find Primary Key and Foreign Key Relationships #sqltips

SQL Interview Question | What is the difference between Translate and Replace

SQL | How to Convert Date / Time Formats ? | Convert | Format

SQL Order Of Execution | In which order does the clauses in a SQL Query execute?

SQL Tricks | How to Remove Unwanted Characters from the Beginning of the String? #sqltips

SQL Tip | Generate a Series in a Single Step ! #sqltips #sqlinterviewquestions

SQL Tricks | How to find value in multiple columns ?

SQL Query | How to find employees retiring at the end of the month | DATEADD | EOMONTH

SQL Query | How to convert data from rows into comma separated single column | FOR XML PATH | STUFF

SQL Interview Query | How many times does a number occur consecutively | Leetcode | Consecutive Nums

PL/SQL | Stored Procedure | Create and Execute a User Stored Procedure

SQL | NOT IN Vs NOT EXISTS (Which one to use?)

SQL Amazing Trick | Calculate Yearly, Quarterly, Monthly totals in a single SQL Query |Grouping Sets

SQL | How to schedule a SQL command | MS SQL | SQL Server Agent

SQL Interview Question - Difference between Count(*), Count(1), Count(colname) | Which is fastest

SQL Tricks | Insert and Update in single statement | Merge #sqltips #sqlinterviewquestions

SQL Trick ! Date Formatting Made Easy ! #sqltips

SQL Tips | How to Find All Tables containing a Column? #sqltips

SQL Tip | Create New Table From Existing Table #sqltips

SQL Incremental data load | 3 ways to perform Upsert | Update else Insert| EXISTS | ROWCOUNT | MERGE

SQL Trick | Custom Sorting #sqltips

SQL Query | Count the occurrence of a character in a string

SQL | Easiest Trick to Sort Alphanumeric Data ! #sqltips

SQL Concepts | Types of Joins | SQL Tutorial

SQL | Answering Your Queries | 9 Complex SQL Queries

SQL Trick | How to Rollup data to Calculate Sub Total and Grand Total in the same query?

SQL Interview Question | How to find strings with lower case characters | Case Insensitive | Collate

Python Pandas Tutorial - 2 | Selecting Rows and Columns