This is a collection of previously published articles on this site about SQL Server Conditional statements. This is for quick reference.
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
Answer to – SQL Assignment-2
The answer to assignment-2 is provided below. If you haven’t visited the post, please do so by clicking here. — Answer to 1st Question SELECT
Answer to – SQL Assignment-3
The answer to assignment-3 is provided below. If you haven’t visited the post, please do so by clicking here. Solution:1 ;WITH CTE AS (SELECT DName,
SQL Assignment-3
This is a simple test or assignment to see how comfortable someone is using SQL at the beginner to advanced level. Exercises of this nature
Named Window functions in MySQL
For queries where numerous OVER clauses would ordinarily define the same window, a WINDOW clause is helpful. Instead, you can create a single definition for
Dataset to practice Windows functions in MySQL
As discussed in the previous post, MySQL is supporting “Window functions” beginning with version 8.0. The window functions enable you to tackle query problems in
Big Data & SQL 