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

Here is the link for SQL Query IQs PART-A ► https://youtu.be/2HybjHUtNtE

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 API Testing Full Play List ► https://bit.ly/2BY0vHu
Link for Web-services Full Play List ► https://bit.ly/3bfK0Ef
Link for Protractor Testing Full Play List ► https://bit.ly/2ztlEIK
Link for Java Programs for Software Testers Full Play List ► https://bit.ly/2ZGeBFC
Link for Java Tutorial Full Play List ► https://bit.ly/2Z3tP8L
Link for TestNG Full Play List ► https://bit.ly/3jGJ3YT

Please subscribe to our channel ► https://bit.ly/2UIvFcm
and press the bell icon to get updates on latest tutorial.

Видео Top 15 SQL Queries Interview Questions and Answers for Software Testing professionals || Part-B канала Software Testing And Automation