Skip to content

I'm excited to share sql top interview asks questions with answers that I've compiled from my learning journey at Qspider/Jspider! 🚀 Whether you’re prepping for interviews or brushing up on your SQL skills, these questions will be super helpful in understanding how subqueries work in SQL.

License

Notifications You must be signed in to change notification settings

AnkushRajMaheYam/SQL-Top-Interview-Questions

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Top Interview SQL Questions: By Ankush Raj

Repository Description:

This repository contains a comprehensive collection of Top SQL Interview Questions, carefully designed to help you prepare and excel in SQL interviews. All queries have been authored by Ankush Raj (or Ankush Raj Mahe Yam).

For a downloadable PDF of these queries, visit my LinkedIn page via the link provided below.


Repository Structure

The Questions are organized into folders, each focusing on specific SQL topics and concepts. Future Questions will follow the same structure and will be added incrementally.

Folder Structure

SQL-Top-Interview-Questions/  
    ├── SubQuery.sql    
    └── (Future Questions will be added in separate file_names)  

Example Questions

Sub_Query_Questions

/*
DISPLAY ALL THE EMPLOYEES WHOSE DEPARTMENT NAMES ENDING 'S'.
*/

SELECT *
FROM EMP
WHERE DEPTNO IN (SELECT DEPTNO
                        FROM DEPT
                            WHERE DNAME LIKE '%S');


Topics Covered in Questions

1️⃣ Subqueries

  • Nested Queries, Single-row, and Multi-row Subqueries.

. . . . . Future Questions will be added in same ways....


How to Use

  1. Clone the repository:

    git clone https://github.com/AnkushRajMaheYam/SQL-Top-Interview-Questions.git  
  2. Execute the .sql file in your preferred database environment (e.g., MySQL, Oracle, or SQL Server).


LinkedIn Post

Check out the full pdf that inspired these questions:
Preview of SQL Sub-Query Questions pdf 👉 SQL-Top-Interview-Questions by Ankush Raj Mahe Yam


About Me

Hi, I’m Ankush Raj or Ankush Raj Mahe Yam (ARMY), an aspiring software developer currently pursuing Java Full Stack Development. I’m passionate about coding and enjoy sharing my learning journey to help others grow.

🌟 Connect with me:


Disclaimer

They are intended purely for educational purposes.


License:
This repository is licensed under the MIT License.


Acknowledgements

Special thanks to the mentor(Akash Sir) and faculty at J-Spider Software Training Institute (Noida Branch) for providing excellent guidance and support throughout the course.

Feel free to explore, practice, and enhance your SQL skills! 😊
Happy practicing SQL! 🎉

About

I'm excited to share sql top interview asks questions with answers that I've compiled from my learning journey at Qspider/Jspider! 🚀 Whether you’re prepping for interviews or brushing up on your SQL skills, these questions will be super helpful in understanding how subqueries work in SQL.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published