Skip to content

Latest commit

 

History

History
108 lines (70 loc) · 3.16 KB

README.md

File metadata and controls

108 lines (70 loc) · 3.16 KB

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! 🎉