Srini

NEXT_DAY Vs DAYNAME Top SQL Examples

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.

SQL: How to Use Sub-query to Delete a Row

This post covers how to use WHERE and DELETE in sub-queries. Useful examples to refer to quickly.

How to Use TO_CHAR Function to Convert DATE

I have explained how to format DATE by using views.

The Ultimate Guide To Aws Shared Responsibility

Cloud computing is popular among the software services. AWS plays top role in the field of cloud computing. Explained AWS shared responsibility model in a way dummies can understand it quickly.

3 Neat SQL Queries to View Table Structure in DB2

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.

Exclusive AWS ElasticCache Memory

I have explained how to implement Cache memory in AWS. It also explained in-memory data store Redis and its benefits.

SQL Inner JOIN By Two Columns Tricky Example

Simple ideas and quickly what you need to find to write a query for joining of two tables explained.

SQL Views: Tricky Interview Question Asked in Many Companies

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.

How to Decode ISO 8583 Bitmap Message

How to calculate or decode which ISO Bits are present or not present in ISO 8583 message. I have explained in easy to understand method.

COBOL ‘EVALUATE ALSO’ Best Examples

Examples for COBOL Evaluate statement for multiple conditions.

COBOL: How to Create a VB Array

In COBOL, Variable-length records stores only in VB or Dynamic arrays. The given sample VB-array logic useful to code in your project.

How to Compare Dates in DB2: SQL Query You Need

Given examples of Date condition in the WHERE clause are useful for DATE comparison.