Here are SQL queries to use the SUBSTRING function along with LOCATE function. LOCATE gives position, and SUBSTRING uses that for the start position.
DB2 popular set operators you can use to filter data from multiple tables. These are useful for your interview and your current project as well.
Cast function the real purpose is to convert data types. This post tells you best examples, rules, and how to use in Data analytics.
SQL where clause the prime purpose is to get records per your filter criteria. This post tells you how to use multiple-like conditions in it.
DB2 SQL is popular in mainframe and open source. I have given DB2 tricky SQL queries for your reference.
I have provided the resolution for ‘Missing IN or OUT parameter at index: 1’ in this post. Useful for all SQL developers.
Creating more indexes is a bad idea. This post covers how to answer this question in an interview. Just use unique indexes in where clause. So you can avoid creating more indexes.
I have shared the Common Table expression of advanced SQL. You can save a lot of CPU time. And you can improve query performance.
Explained the complete features of SQL Aggregate functions.
DATE calculation in SQL is tricky. Sometimes you need to find Day name, Day of the week, and Next Day Date. These example SQL queries useful for you.
This post covers how to use WHERE and DELETE in sub-queries. Useful examples to refer to quickly.
I have explained how to format DATE by using views.