SQL in Tamil | By Guhan | Order By and Group By Part 15 | SQL Training in Chennai | Payilagam

[@sa_2268]

Thank u bro it was useful 🤗

[@balajims_]

thanks anna, i learn having , whare and grp by ord by

[@kanagarojag6928]

well bro i am a stu from cbse but ur teaching gud

[@abik7202]

Super bro

[@legend020goat]

So having use pannanumnaa count use pannanumo

[@prasanth5621]

Super

[@sudhakannan4746]

🙏🙏

[@tamil6245]

Oru doubt bro distinct m group by m same a tha irukku so 2 kum ulla different sollunga..

[@marimuthu.g74]

Bro how to use order by and group by in singal querie

[@ShittheswaranSelvakumar]

nanari..

[@anandakumar2712]

Bro, need to write subwuery can you make a video for that

[@balajims_]

yaya i also want this subquery concept

[@mani.kandan4020]

Bro city eppudi Maria db thariyum

[@simonraj8990]

SELECT Gender,count(*) FROM test GROUP BY Gender HAVING Place ='Chennai';
sir, in 12th cs book page no 226, having clause shows error...
kindly re correct the above query for me sir... please

[@mrrvs-ux6my]

Select count(*),gender from test group by gender having place="chennai"; your mistake was gender in first ....😉

[@abik7202]

@@mrrvs-ux6my gender first varalam bro but without comma

[@prvindev902]

Hi bro, need query for below scenario
Imagine, i have 50 departments in our company.. here, how to take only top second salary for each departments

[@aakashp7808]

SELECT salary FROM (SELECT salary FROM departments ORDER BY salary DESC LIMIT 2) as second_max ORDER BY salary ASC LIMIT 1;

[@kirankumarmanchur3049]

Low voice