Top 10 SQL Interview Questions: Basic to Pro Sql Views Simplified

[@sumitchaudhari5815]

can you please make video on sub-queries by writing complex sub-queries and tell us how does it get executed i mean way of execution of subqueries or sequence of execution in subqueries and performance optimization (regarding performance optimization i have no idea)

[@TechAndTalkConnect]

Please check out the post I have answered in the post section with details

[@sumitchaudhari5815]

i did able to find about performance optimization but not able to find about sub-queries@@TechAndTalkConnect

[@shalinisawarn8791]

Great 👍 please make a video on most asked interview questions for Fresher Data Analyst.

[@TechAndTalkConnect]

Thank you! I appreciate your suggestion. I'll work on a video covering the most asked interview questions for fresher data analysts. Stay tuned!

[@khalidazizi8346]

Please make a interview video on stores procedure

[@TechAndTalkConnect]

I appreciate your suggestion and I'm working on creating content about stored procedures. Stay tuned to Tech and Talk for more exciting content! Your patience is much appreciated

[@khalidazizi8346]

Thank you so much

[@AP-tn7yh]

Create view max_dept as select dept_name ,max(salary) from emp group by dept_name;

[@AghAAwais-c8t]

Please make Master tables View Primary kay Create Master Table or Main Tables

[@Surya-r9v]

Could you Plz share data set.

[@TechAndTalkConnect]

thanks for comment please refer the dataset scripts from this link: drive.google.com/file/d/1Gm0qeSIqui5CK4RC0i89hRsNehSlqIhN/view?usp=drive_link

[@Mahesh_05_28]

Create view max_salary As Select dept_name,max(salary) from employee Group by dept_name;

[@remoashok9191]

Create view Total_Salary As Select Max(Salary),dep_name from departments group by dep_name;

[@ashuverma6183]

CREATE VIEW V16 AS SELECT DEPTNO, MAX(SAL) AS MAX_SAL FROM EMP GROUP BY DEPTNO;