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

Рет қаралды 47,868

3 жыл бұрын

Here is the link for SQL Query IQs PART-A ► • Top 15 SQL Interview Q...
Here you will learn Top 15 SQL Queries interview questions and answers asked to software testers.
16. Write a query to fetch all data from Employee table ?
17. Write a Query to fetch details of male employees?
18. Write a Query to find Max Salary from each department ?
19. Write a Query to print the name of distinct employee whose Salary is between 30000 to 35000 ?
20. Write a Query to find employee whose Salary is equal or greater than 40000 ?
21. Write a Query to find name of employee whose name Start with ‘S’ ?
22. Write a Query to find maximum salary for a lady employee?
23. Write a Query to get nth(3rd) Highest Salary?
24. Write a Query to get nth(3rd) Lowest Salary?
25. Write a Query to Insert a new employee details ?
26. Write a Query to update salary of an employee Yashika to 34000.
27. Write a Query to Delete details of employee named as Deepak ?
28. Write a Query to fetch all details from both Employee and Company table ?
29. Write a Query to fetch company name of the lady employee who is getting highest salary?
30. Write a Query to Create a table and drop same table ?
Additional Info
Link for SDET/QA Interview Full Play List ► bit.ly/3frBpQZ
Link for API Testing Full Play List ► bit.ly/2BY0vHu
Link for Cypress Tutorial Full Play List ► bit.ly/3iMdi2a
Link for Web-services Full Play List ► bit.ly/3bfK0Ef
Link for Protractor Testing Full Play List ► bit.ly/2ztlEIK
Link for Java Programs for Software Testers Full Play List ► bit.ly/2ZGeBFC
Link for Java Tutorial Full Play List ► bit.ly/2Z3tP8L
Link for Selenium Tutorial Full Play List ► bit.ly/3vFR9X5
Link for TestNG Full Play List ► bit.ly/3jGJ3YT
Please subscribe to our channel ► bit.ly/2UIvFcm
and press the bell icon to get updates on latest tutorial.
#softwaretestingandautomation #subhasishmishra #softwaretesting #selenium #apitesting #java #restassuredapiautomation #testng #sql #unix #automationtesting #softwaretestinginterviewquestionandanswers #testautomation

Пікірлер: 64

@pratikpoojari1212 2 жыл бұрын

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.

@lkkota41 Ай бұрын

thanks for your effort

@user-lf2no6vy5l 7 ай бұрын

thanks sir cleared more concept

@baan1221 3 жыл бұрын

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

@SoftwareTestingAndAutomation 3 жыл бұрын

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

@avinaashkr17 3 жыл бұрын

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

@SoftwareTestingAndAutomation 3 жыл бұрын

Thank you!!! Keep learning new things 😊

@705chacko 3 жыл бұрын

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

@SoftwareTestingAndAutomation 3 жыл бұрын

Thank you 😊

@rohitpardeshi7084 2 жыл бұрын

Very informative video. Thank you.

@SoftwareTestingAndAutomation 2 жыл бұрын

You are welcome. Keep sharing with your friends 😊

@snowguo1786 2 жыл бұрын

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

@SoftwareTestingAndAutomation 2 жыл бұрын

Great !! Keep learning and sharing with your friends 😊

@swapnilsawarkar3408 2 жыл бұрын

Very helpful sir thanks.

@SoftwareTestingAndAutomation 2 жыл бұрын

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

@pritibarathe9193 2 жыл бұрын

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

@SoftwareTestingAndAutomation 2 жыл бұрын

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

@riteshroy4940 3 жыл бұрын

Great sir

@SoftwareTestingAndAutomation 3 жыл бұрын

Thank you :-) keep learning new things.

@harmeetheir6207 2 жыл бұрын

very helpfull thankyou.

@SoftwareTestingAndAutomation 2 жыл бұрын

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

@k9870 2 жыл бұрын

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 2 жыл бұрын

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

@omthakurgulshan534 2 жыл бұрын

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

@k9870 2 жыл бұрын

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

@kavithareddy5572 2 жыл бұрын

Explained very clear 🙏

@SoftwareTestingAndAutomation 2 жыл бұрын

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

@vaibhavmane4902 Жыл бұрын

Very useful ❤️

@SoftwareTestingAndAutomation Жыл бұрын

Glad it was helpful!

@mohamedkaleemullah1161 Жыл бұрын

This video was very useful..

@SoftwareTestingAndAutomation Жыл бұрын

Glad it was helpful!

@butterfly7976 3 жыл бұрын

Very nice video

@SoftwareTestingAndAutomation 3 жыл бұрын

Thank you 😊

@prajnadayalan535 3 жыл бұрын

Super make more videos🎉🎉🎉

@SoftwareTestingAndAutomation 3 жыл бұрын

Sure 😊

@vinaybijalgaonker4494 2 жыл бұрын

Good question

@SoftwareTestingAndAutomation 2 жыл бұрын

Thank you !! keep sharing with your friends 🙂

@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

@abhaygolhar7817 2 жыл бұрын

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

@gaya353 3 жыл бұрын

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 3 жыл бұрын

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

@divyakandy 3 жыл бұрын

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

@prathyusha704 3 жыл бұрын

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 3 жыл бұрын

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');

@mr.perfect1205 11 ай бұрын

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

@ChandraSekhar-kl9ue 2 жыл бұрын

how for sql queries requires in testing plz explain

@SoftwareTestingAndAutomation 2 жыл бұрын

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

@akashsonawane650 3 жыл бұрын

can you give a 2 high salary from each group

@SoftwareTestingAndAutomation 3 жыл бұрын

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

@gitikagujrathi4853 2 жыл бұрын

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 2 жыл бұрын

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 2 жыл бұрын

Ok thank you