DAI(Data & AI)

Ad Code

Responsive Advertisement
Write SQL Query to fill the missing months with previous months salary

Write SQL Query to fill the missing months with previous months salary

Sreenu Y February 25, 2025

Write SQL Query to fill the missing months with previous month’s salary? Video   To achieve the desired output, we can …

Read more
SQL Join Interview question: Different types of SQL joins and describe the output each type produces?

SQL Join Interview question: Different types of SQL joins and describe the output each type produces?

Sreenu Y December 31, 2024

What is the output of below query for all joins?         SELECT T1.* FROM  T1 JOIN T2 ON T1.C1=T2.C1 AND T1.C2&l…

Read more
SQL Question:Write an SQL query that checks for email addresses with at least 8 alphabetic characters before the "@"

SQL Question:Write an SQL query that checks for email addresses with at least 8 alphabetic characters before the "@"

Sreenu Y December 21, 2024

SQL Query:  Write an SQL query that checks for email addresses with at least 8 alphabetic characters before the "…

Read more
SQL Convertion Query using Oracle, MySQL, PostgreSQL and SQL Server

SQL Convertion Query using Oracle, MySQL, PostgreSQL and SQL Server

Sreenu Y December 11, 2024

Write to SQL query to Classify the values in the column based on criteria. For instance, the Name column in the source …

Read more
How to extract the filename from a given file path using different SQL databases: Oracle, MySQL, SQL Server, and PostgreSQL.

How to extract the filename from a given file path using different SQL databases: Oracle, MySQL, SQL Server, and PostgreSQL.

Sreenu Y November 22, 2024

How to extract the filename from a given file path using different SQL databases: Oracle, MySQL, SQL Server, and Postgr…

Read more