Top 15 SQL Queries Interview Questions and Answers for Software Testing professionals || Part-B

[@pratikpoojari1212]

Doubt in 19th question - Distinct for Firstname is incorrect I believe. The question was to display all the employees having salary btw 30 and 35 so both 'Yashika' were supposed to get displayed as one of them has 32 and other one has 34 salary.

[@k9870]

Hey subhashish,I completed your java programming questions series & now doing SQL for a quick recap..from your java programming series I am getting most of the questions in interview...thanks for it... subscribed,,,😊

[@SoftwareTestingAndAutomation]

I am glad to hear that 😊 share it with your friends.

[@omthakurgulshan534]

I can't found​ java programming question answer . Please help

[@k9870]

@@omthakurgulshan534 Check in his playlist section,total 32 java programming questions are there

[@705chacko]

Watched both videos start to finish in one sitting. Very good job Subhasish Mishra.

[@SoftwareTestingAndAutomation]

Thank you 😊

[@rajivkrishnasamy9519]

Really superb bro Nth highest salary query is different approach thank you

[@SoftwareTestingAndAutomation]

So nice of you.

[@rajivkrishnasamy9519]

@@SoftwareTestingAndAutomation in hexaware interview @april 14 I had written this query but the interviewer asked me is it working

[@baan1221]

Thank you so much for this video. This was the fastest recap on SQL commands and queries. very useful for QA interviews.

[@SoftwareTestingAndAutomation]

I am glad, this is helpful. share it with your friends :-)

[@snowguo1786]

Thank you, all the questions are clear! I am able to find my mistakes from your questions

[@SoftwareTestingAndAutomation]

Great !! Keep learning and sharing with your friends 😊

[@kunalmalpure7933]

Thank you so much i have learn from this lot . it will be very helpful for me for the interview.

[@swapnilsawarkar3408]

Very helpful sir thanks.

[@SoftwareTestingAndAutomation]

Glad to hear that!! Keep learning and sharing with your friends 😊

[@Abhishekrajducat]

thanks sir cleared more concept

[@pritibarathe9193]

Thank you so much... nicely explain all the queries... initially I find it very hard now it's seems to b easy...🙂👍

[@SoftwareTestingAndAutomation]

Thank you !!Keep learning and sharing with your friends 😊

[@kavithareddy5572]

Explained very clear 🙏

[@SoftwareTestingAndAutomation]

Glad to hear that!! Keep learning and sharing with your friends 😊

[@lkkota41]

thanks for your effort

[@avinaashkr17]

Very Useful Video One Of The Best SQL Question Video In KZbin.. Thanks A Lot.

[@SoftwareTestingAndAutomation]

Thank you!!! Keep learning new things 😊

[@harmeetheir6207]

very helpfull thankyou.

[@SoftwareTestingAndAutomation]

Glad it was helpful!! Keep learning and sharing with your friends 😊

[@rohitpardeshi7084]

Very informative video. Thank you.

[@SoftwareTestingAndAutomation]

You are welcome. Keep sharing with your friends 😊

[@vaibhavmane4902]

Very useful ❤️

[@SoftwareTestingAndAutomation]

Glad it was helpful!

[@gaya353]

Hi Subhasish, I had an interview yesterday and I was asked this question on SQL. Could u pls help me with the answer. Qn: How to delete duplicate records from a table?

[@SoftwareTestingAndAutomation]

Try this - DELETE FROM EMPLOYEE WHERE EMP_ID NOT IN(SELECT MAX(EMPID) AS MaxEmployeeID FROM EMPLOYEE GROUP BY FirstName, LastName, Country);

[@divyakandy]

@@SoftwareTestingAndAutomation max (emp ID) returns maximum value of the Employee ID right, should we use the count(EMP ID)?

[@prathyusha704]

Can you write this query 'Write a Query to fetch company name of the lady employee who is getting highest salary?' with out full join keyword like you told before inner join(31:52)

[@SoftwareTestingAndAutomation]

Try this, SELECT COMPANY_NAME FROM EMPLOYEE emp, COMPANY cmp where emp.EMP_ID=cmp.EMPLOYEE_ID and emp.SALARY in (SELECT MAX(SALARY) FROM EMPLOYEE where gender='Female');

[@vinaybijalgaonker4494]

Good question

[@SoftwareTestingAndAutomation]

Thank you !! keep sharing with your friends 🙂

[@prajnadayalan535]

Super make more videos🎉🎉🎉

[@SoftwareTestingAndAutomation]

Sure 😊

[@mr.perfect1205]

Plz add simple queries why you are making hard in nth max we can make use n-1 is enough

[@abhaygolhar7817]

Can we use dense_rank in 23rd question... Select * from(select employee. *, dense_rank over(order by salary desc) as highestsalary from employee) where highestsalary=3

[@gitikagujrathi4853]

There is two table one is employee table it will consists of emp_id, emp_name, emp_salary, and dept_id columns and another table consists of dept_number, dept_name to print emp_name, emp_salary, dept_name of an employee whose salary is maximum plz tell how to write query of this question. SIR PLZ TELL ME THE ANSWER .

[@SoftwareTestingAndAutomation]

First you need to join both the tables using a primary key then you can use the same query given in the video to find maximum salary. If you don't know which is the primary key you can ask it to the interviewer. Below example you can try:- SELECT a.employee_id, a.first_name, a.last_name, a.salary, b.department_name FROM employees a, departments b WHERE a.salary IN (SELECT MAX(salary) FROM employees) AND a.department_id=b.department_id ;

[@gitikagujrathi4853]

Ok thank you

[@riteshroy4940]

Great sir

[@SoftwareTestingAndAutomation]

Thank you :-) keep learning new things.

[@ChandraSekhar-kl9ue]

how for sql queries requires in testing plz explain

[@SoftwareTestingAndAutomation]

Testers should have good SQL knowledge to perform data base testing and it is basic skill for QA.

[@butterfly7976]

Very nice video

[@SoftwareTestingAndAutomation]

Thank you 😊

[@akashsonawane650]

can you give a 2 high salary from each group

[@SoftwareTestingAndAutomation]

Try this - Select Department,Max(Salary) From (Select E1.Department,E1.Salary From Employee E1,(Select Department,Max(Salary) as Salary From Employee group by Department) E2 Where E1.Department = E2.Department And E1.Salary

[@ANRR995]

Update command I do rarted update table name set sal=36000 wher emp_id ;

[@famousbirds8800]

How to find nth highest salary??

[@ANRR995]

Moru of the name is same retyo now

[@ChandraSekhar-kl9ue]

everything is in blur not able to view

[@nikhilchougule5780]

Query to get salary of all employees except Ram

[@SoftwareTestingAndAutomation]

SELECT salary FROM Employees WHERE NOT employeename='Ram';

[@mohamedkaleemullah1161]

This video was very useful..

[@SoftwareTestingAndAutomation]

Glad it was helpful!

[@sivaranjanis9019]

Great sir

[@SoftwareTestingAndAutomation]

Thank you!! Keep learning and sharing with your friends 😊

[@sivaranjanis9019]

Sure sir