Here’s SQL Query you can get Year from two DATEs. You can achieve this with DATEDIFF() function in MySQL.
Author: Srini
Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.
Here are ideas on how to use STOP, START, SHUTDOWN, BOOT mindfully on internal processes of Linux operating systems.
IDCAMS DEFINE Utility you can use to define VSAM files. Here are the parameters to consider while creating them.
Sample SQL Query to Join three tables with WHERE clause. It is Tricky SQL query helpful for interviews.
Here are SQL queries to use the SUBSTRING function along with LOCATE function. LOCATE gives position, and SUBSTRING uses that for the start position.
Here are the python technical interview questions helpful for your next interview.
In Python, both tell and seek functions help you get the data from a file. How to use these explained on how to use in your current project.
You can learn interview questions for the Kafka administrator role here. The questions covered prime points of the Kafka server.
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.
HBase is a NoSQL database in the Hadoop framework. Correct installation needed to work with HBase database. These are steps for quick installation without errors.
Cast function the real purpose is to convert data types. This post tells you best examples, rules, and how to use in Data analytics.
You can use multiple LIKE condition in SQL WHERE clause. Here is an example for your quick reference.
