SQL TUTORIAL for Beginners | SUBQUERY in SQL

Sub query or nested query is very powerful technique to fetch data from RDBMS. In this SQL tutorial video all the major types of sub queries are explained with example and at the end of the video practice questions for sub queries are also given.

[@hiranaeem7582]

Jazak Allah o khairah Sir g 🙏🙏🙏🙏 Thanks

[@maoon9449]

Query ❤ owesome sir جزاك الله الخیرا

[@zobialatifzobialatif1205]

Amazing sir g👌

[@huzaifakaramat5042]

Thank you so much sir 🔥👑

[@tahirimtiaz]

Most welcome

[@maliknoman5215]

Sir g next video b send kr dy table and html ki jazakallah sir g plz

[@tahirimtiaz]

Ek 2 din mn share ho jae gi in sha Allah..

[@huzaifakaramat5042]

Allah Razi ho AP se

[@innocentperson7194]

Sir for count(hiredate).... & more than one value we want to know than what query will be written.... For example we want 2 know the number of employees hired in 1981,81,83 so....????

[@tahirimtiaz]

Good to see that you are curious to learn. This problem can be solved in many ways. One of them is to use a type conversion function. We can use TO_CHAR(Date, ' format') to convert date value in to character. So if we write TO_CHAR(hiredate, 'YY') it will return last two digits of any hire date like 81,82. And then we can compare these values by using in operator. Here is the final query that will give you the required result. select count (hiredate) from emp where TO_CHAR(hiredate, 'yy' ) in ( '81' , '82' , '83' ) ; Remember we are converting date to character value so we will use single quotes.

[@innocentperson7194]

@@tahirimtiaz okay thankewww sir