SQL Exercises

SQL Exercise – 22

by Pradeep Raturi
SQL Exercises

SQL Exercise – Create a function that accepts a start date, an end date, and a day of the week (e.g., “Monday”). The function should return a table listing all dates within the specified range that match the given day of the week.

SQL Exercise – 21

by Pradeep Raturi
SQL Exercises

SQL Exercise:

Mask Sensitive Data with * based on character lengths
Write a query to mask sensitive data such as email address, Phone Number and Aadhaar Number in the given table dynamically, where the number of * corresponds to the length of the characters being masked.

SQL Exercise – 8

by Pradeep Raturi
SQL Exercises

SQL Exercise: Create a SQL function that takes a string as input and removes all special characters (keeping only alphanumeric characters and spaces). The following… Read More »SQL Exercise – 8

SQL Exercises

SQL Exercise – 22

Share this:

SQL Exercise – 21

Share this:

SQL Exercise – 8

Share this: