Blog Archives

15+ SQL scenarios based interview questions answered

Q1 How will you go about identifying duplicate records in a table?
A1 The following SQL query will do the trick.

Note: Interviewer is testing if you understand that the aggregate queries need to have a “GROUP BY

Read more ›



Common Table Expressions (i.e. CTE) in SQL using the “WITH” clause

Common Table Expressions or CTE’s for short are used in SQL to simplify complex joins and subqueries, and to provide a means to query hierarchical data such as an organisational chart. This was also introduced in MySQL 8 – Using https://www.db-fiddle.com/. … Read more ›...

Members Only Content
Log In Register Home


SQL retrieving the latest records interview Q&As

This question can reveal a lot about your ability to write SQL queries as different approaches can be used and there will be drill down on pros and cons of each approach. Q1. Given the following SQL, how do you retrieve the latest records by updated date for each user?...

Members Only Content
Log In Register Home


SQL window function for analytics & qualify interview Q&As

Data Engineers & analysts must know the Window functions as it is a powerful tool to analyse the data. This post compliments “Apache Spark window functions” focus on using SQL on MySQL server covered. You can also apply this on Big Data SQL engines like Hive & … Read more...

Members Only Content
Log In Register Home


800+ Java Interview Q&As

Prepare to fast-track & go places
with multi-offers to choose from & increased earning potential. Expand your horizons along the way by taking the road less travelled.
Learn by categories on the go...
Learn by categories such as FAQs – Core Java, Key Area – Low Latency, Core Java – Java 8, JEE – Microservices, Big Data – NoSQL, etc. Some posts belong to multiple categories.
Top