Skip to main content

SQL real-time interview Queries along with answers sources

 Hi All, 

Today I was inspired by few sites where I saw few SQL queries that are been asked in interviews a lot and wanted to share with you all. So, that everyone can benefit of it.

https://www.techbeamers.com/sql-query-questions-answers-for-practice/ 

https://www.complexsql.com/real-time-scenarios-in-sql-queries/  

https://www.complexsql.com/complex-sql-queries-examples-with-answers/complex-sql-for-interviews/ 

https://www.interviewbit.com/sql-interview-questions/

https://www.softwaretestingmaterial.com/sql-interview-questions/

Labels:

Comments

Post a Comment

Popular posts from this blog

SQL Real Time Interview Questions with solutions

SQL_Query : In this MySQL challenge, your query should return the names of the people who are reported to (excluding null values), the number of members that report to them, and the average age of those members as an integer. The rows should be ordered by the names in alphabetical order. Your output should look like the  following table . Solution : SELECT  ReportsTo ,   count ( ReportsTo )   as  Members ,   round ( avg ( Age ),   0 )   as   'Average Age'     FROM  maintable_MS9H0 Where  ReportsTo  is   not   null Group   by  ReportsTo order   by  ReportsTo or SELECT  ReportsTo , COUNT ( FirstName )   as  Members , ROUND ( AVG ( Age ))   as   "Average Age"   FROM  maintable_MS9H0  WHERE  ReportsTo  IS   NOT   NULL   GROUP   BY  ReportsTo SQL_Query: In this MySQL challenge, the ta...
Post a Comment
Read more

Joins in NoSQL world

                             : Joins in NoSQL world: Here in NoSQL world, we have $lookup aggregate function for performing joins and it performs left outer equi-join functionality. This aggregate function is only available from MongoDB 3.2 versions only. The Left outer equi-join produces a result set that contains data for all documents from the left table (collection) together with data from the right table (collection) for documents where there is a match with documents from the left table (collection). See the diagram below                      $lookup – Left Outer Equi-Joins Below diagram illustrates the syntax for performing the join: 1)    leftCollection is the collection that the aggregation is being performed on and is the left collection in the join 2)    from identifies the collection that it will be joined with – the ...
Post a Comment
Read more

SQL Basics To Intermediate Topics

This post talks about SQL: SQL stands for Structured Query Language, the name itself states that this language is used to query the existing database with certain operations and with SQL we can create tables so on. SQL commands are categorized into 4 categories. They are 1) DDL (Data Definition Language) : It is used to define the database structure and schema. Commands used in the DDL are - CREATE (this command is used to create new table, table from existing table, index, function, views, store procedure and triggers) Syntax: - ALTER (this command is used to change the structure of existing database) - DROP (this command is used to delete an object from database) - TRUNCATE (this command is used to remove all records from a table, including all spaces allocated for the records are removed) - COMMENT (this command is used to add comments to the data dictionary) - RENAME (this command is used to rename an object existing in the database) 2) DML (Data Manipulation Language) : These are...
Post a Comment
Read more