53 SQL Interview Questions | SQL Query Based, Common, Advanced, and Mostly Asked SQL Questions

[@NitManTalks]

Thank you all for your love and Support. And I really hope this video helps you to crack your interviews.
53 SQL Questions-Answers -docs.google.com/presentation/d/1IqV_h8SdailZMyvuzlzzCuoplXQ6fp64KMjFxORAZx0/edit?usp=sharing
Thanks and Much Love To You ALL!!!❤
PS: Do let me know in the comments if this video helps you in order to get shortlisted in any company.
❣💥🤘
Regards,
NitMan

[@techgraph1233]

Hats off brother. I'm a Data Engineer by profession, and I can definitely say that this video has covered the most asked interview question from my perspective as well. Just want to add sometimes they ask Merge,CTE and Triggers in an advanced questions.

[@NitManTalks]

Thank you so much ✌️🔥

[@shubhamsachan7052]

Select count(name) ,dept from employee
Group by department_id
Order by dept;

[@NitManTalks]

Great!!!

[@relaxing_beats1]

answer for question question no -16 : select department_id, count(*) from employee group by department_id order by count(*) desc;

[@theraizadatalks14]

Also, You deserve a lot of subscribers for the way you explain any question in a very simple manner. Thanks a lot ❤️

[@NitManTalks]

Thank you so much 😀

[@nomeshthakare9352]

Thank you for this amazing indepth Question bhaya.

[@syedkashifnaqvi7617]

Bro apka fan hu gya mai experience Django developer hu interview dyna hy aj so maza aa gya ap ne kafi chzy revoise krwai hy django mai interview quesion ki vide se ap es ki be sunta hu or be mjhe btain kn kn si kro links dain yha pe
Backend developer ka interview hy myra

[@rajatnagwal7881]

select deptid,count(*) from emp group by deptid order by count(*) asc;

[@sangeetha4715]

Thanks a lot brother 🥰🥰...god bless you 😊😊😊...

[@oniichann-gaming]

For each dept employee we need to do : select dept , Count(*) from emp group by dept

[@seemakanyawal5307]

Your all vedios are very helpful

[@Devi_Shylu]

Useful 👍

[@nilamkudale7292]

Select department , count (*) as dept_cnt from employee group by department order by dept_id

[@oniichann-gaming]

select Count(dept) as cnt ,Name from emp group by Name order by cnt ;

[@Dhananjaysingh-ym8ey]

amazing video, most relevent channel ever......
expecting the ans video soon

[@NitManTalks]

Very soon

[@dolla_shrey]

select distinct dept_id, emp_cnt
from
(select dept_id, count(emp_id) over(partition by dept_id order by dept_id)emp_cnt
from employee_a
order by emp_id)
order by emp_cnt;

[@rahulsaha2859]

I gave an interview on Friday they were asking about Linux shell questions and git based questions. I suggest you also prepared a list of these questions. Also web based questions for experienced people .

[@NitManTalks]

Git is already ready. Will make it public soon.

[@somsankarbehera7580]

Bro are you getting any job or not

[@amanraheja2905]

Nice video Bhai

[@SpyandWar_Stories]

We will use group by clause and sort by with the count

[@9844468928]

16. question answer---
select count(*) as CNT ,dept.DNAME
from emp
inner join dept on emp.DEPTNO = dept.DEPTNO
group by dept.DNAME
order by CNT

[@NitManTalks]

Great!!

[@pranshu_tiwari]

Thanks for the video bhaiya.. 🎉🎉

[@khetrabasitechvideo362]

Thanks so much sir .... Great job... Please create a large python django APIs project for experience... Previous video is not for experience plzz sir

[@priyankapatil-jn9wx]

I am looking for same

[@NitManTalks]

Thanks bro.
But for django project, it will gonna take some time.

[@khetrabasitechvideo362]

@@NitManTalks ok we will waiting this type of videos

[@syedhusnain5470]

Informative content 🔥🔥

[@tiyasadey2211]

Thank you very much , Great job 👍

[@tteejjj]

16.ans-->
Select dept, count (dept) from emp
group by dept
having count (dept)>1
order by dept asc;
!!!!!?

[@NitManTalks]

You don't need "having count (dept)>1".
You can simply use:
"Select count(dept) ,dept from emp
group by dept
order by dept;"

[@jatinnandwani6678]

Thanks man

[@sushmitha8247]

Tqsm senior 🤩🤩🤩🤩🤩

[@NitManTalks]

Shukriya 🔥

[@magicalmagie2889]

Sir can u please upload the video for sql queries get details of employees working on some departments

[@nakulanand2725]

Thanks for this useful info bro, sabke solutions bhi provide krwa dete 😅

[@NitManTalks]

Krwa diye huye hai already bhai.
Checkout my channel.☺️✌️

[@nakulanand2725]

@@NitManTalks ok bro got it.

[@vikeshsharma9819]

Sir in Questions k Answers ki Video Bhi Daal do🙏🙏

[@pawanchaturvedi8973]

Great, man keep the content coming !!

[@mk-ov4js]

Can I know what's the reason that u take always 53 questions .......What's the magic hidden in these numbers 53 and 200.

[@NitManTalks]

Hahahahahah. There is nothing as such.
Whenever I count total Questions, it's always be around ~50.
Python - 52
Django - 54
Sql - 53
Nd git is also gonna be around 52-56😅😅😅

[@mk-ov4js]

@@NitManTalks 😂🤣 . Okay , My intelligence went wrong . I thought something else 😝 .

[@NitManTalks]

@@mk-ov4js 🤣🤣

[@maliksaab2235]

@@NitManTalks mk for tableau

[@jyotiaggarwal8785]

Please upload kafka and elastic search interview questions

[@khushicute]

Thanks for this video, when will u share the answers to these questions??

[@NitManTalks]

As soon as possible

[@nishushroff9656]

Are these kinds of questions relevant for experienced data analyst interviews too?

[@NitManTalks]

It’s Relevant for all SQL based Interviews!

[@nishushroff9656]

@@NitManTalks okay🤘... Thank you for your great content ❤

[@divyakerekar8971]

Different between mssql and Sql?

[@rahuljangir2843]

bhaiya m interview de rha hu as a python back end developer mujse mostly main questions API or Rest API k hi puchte h, Ak DRF ki video jarur bnana

[@NitManTalks]

Jrur.✌️

[@sureshaakunoor]

Can a non it guy learn and give interview, what will be the chance of hiring..

[@magicpantsgamer6771]

Thank for this questions sir
Just wanted to know how much
1) data structures and algorithms you should know to join a company /
To for entry level position ?

[@NitManTalks]

It's not mandatory, but it's good to have knowledge about it.

[@kavyashrihunashikatti8038]

Hi
Could you please tell me, how u switch from tcs to other company..how u applied for that new job.

[@NitManTalks]

Already explained that Scenerio in one of my video.
Suggest you to please watch it on my channel.

[@polytuts9067]

When answer will be upload...

[@vickymore8752]

Bro
Please post GIT and Unix command comman interview questions

[@NitManTalks]

Git is already created!!! Please do check my playlist "All In One"

[@sadsfization]

sir ap pdf kab de rahe ho

[@ravimane5508]

You could have provided answers also.

[@NitManTalks]

Already provided.. please check All In One Playlist

[@naveenkumarnaravala]

A link to download pls

[@NitManTalks]

Please check my telegram group or check link in comment section

[@s.pkashyap6289]

Bhai ans.bhi post kar dete to kya bat hoti

[@NitManTalks]

Already Posted!!
Checkout my “All In One” playlist!

[@sangameshratkalle9648]

Answer

[@NitManTalks]

Working on it

[@estefaniaperez2690]

it will be great if the video is 100% in English

[@naveenandhavarapu9456]

where is the answers

[@NitManTalks]

Go to All In One Playlist.
You will find there.

[@dipusarker8072]

Where is answer?

[@theraizadatalks14]

He'll post soon

[@NitManTalks]

Will upload soon...!!

[@dipusarker8072]

@@NitManTalks Thanks for your kindness

[@aliabbas-jc4lf]

Send me pdf file link...

[@NitManTalks]

Must have mentioned Telegram Group Link In Comment Section. Please do check

[@saurabhkhandelwal1507]

Abe answers kaha hai ?

[@ShubhamBhushanCC]

SELECT dept_id, COUNT(emp_id) FROM department
GROUP BY dept_id
ORDER BY COUNT(emp_id);

[@cartoofun]

Also, You deserve a lot of subscribers for the way you explain any question in a very simple manner. Thanks a lot ❤