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

Defect Triaging and Priority vs Severity

 I fount the following sites explained clearly about defect triaging and felt worth to share it my blog to help others.  This question was been asked in many interviews as well "What is defect triaging? And how do you handle it?". Defect Triaging Meeting:  http://www.testingdiaries.com/defect-triage-meeting/#:~:text=Defect%20Triage%20Meetings%20are%20project,are%20defined%20for%20the%20bugs. Defect Triage:  https://www.guru99.com/bug-defect-triage.html#:~:text=Defect%20triage%20is%20a%20process,and%20priority%20of%20new%20defects. Priority Vs Severity:  https://www.guru99.com/defect-severity-in-software-testing.html https://www.softwaretestinghelp.com/how-to-set-defect-priority-and-severity-with-defect-triage-process/
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