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.
SQL procedure saves your time when writing it for repetitive tasks. On top of that, writing code with Labels improves readability. So that maintenance is easy.
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.
Three top SQL queries you need to get Table metadata. Metadata means Table structure. That means to know indexes and columns of a Table in question.
How to write SQL procedure in DB2 explained with coding guidelines.
In this post, I have answered one tricky SQL-view interview question. Views availability after the base table modified confuses many developers. I provided an answer to this.
I have explained on how to give multiple conditions in the SQL WHERE clause with examples