Hello Prime Coders, IMDB data set: drive.google.com/file/d/1SRteUqv9Q7zUj-5COqyAraIp27d8JgZm/view?usp=sharing Question Corrections below: 1. There is improvement in the question(Q 50), there should be How do you select all the movies that have the highest rank score in the database? Now the solution makes sense. Sorry for the inconvenience. Explanation of the query: The WHERE clause uses the >= ALL operator to ensure that the rankscore of each selected movie is greater than or equal to the maximum rankscore found by the subquery. Since the subquery returns only the maximum rank score, >= ALL effectively means rankscore >= max(rankscore), which selects movies with the highest rank score. 2. In question 18, '=NULL' should be replaced by 'IS NULL';
Please make a video on how to explain projects and what if we have only basic project, also what if we have not done any internship what reason can we give.
Hey Aditya, I found this video very useful. I was going through the interview experience and similar questions that you have covered in this video. Please keep uploading it is really helpful.
@@ShiyaamsundharVetrivel please go through the question. You should return the answer in a group not in rows. If questions states you need to return the answer in row the. Surely u can use where clause!
Sir I have a doubt, in the 42Q of this video, why can't we use normal query using where clause, select name, year from movies where year>2000; in this also we are not using group by clause right? tell me whether I am correct or wrong , or did I miss any condition
50Q Ans. SELECT a.first_name, a.last_name FROM actors a WHERE a.id IN ( SELECT r.actor_id FROM roles r WHERE r.movie_id = ( SELECT m.id FROM movies m WHERE m.name = 'Schindler''s List' ) );
If you have mentioned Excel in your resume then you expect questions on excel. Excel I will see because I don't have much knowledge about excel as its not a technical stuff.
There is improvement in the question, there should be How do you select all the movies that have the highest rank score in the database? Now the solution makes sense. Sorry for the inconvenience. Explanation of the query: The WHERE clause uses the >= ALL operator to ensure that the rankscore of each selected movie is greater than or equal to the maximum rankscore found by the subquery. Since the subquery returns only the maximum rank score, >= ALL effectively means rankscore >= max(rankscore), which selects movies with the highest rank score.
Hi, you must know the basics of blockchain. They can ask you any basic question. Try to cover all the questions related to your project. Like why did you use this technique etc.
No, it is written in the question that you have to write the query without using GROUP BY (means you have to print the output in GROUPs without using GROUP BY keyword) so you need to use HAVING which deals with groups . You can use 'where' if you want to deal with rows.
Microsoft SQL Server supports fewer platforms than MySQL. MySQL supports more programming languages than SQL Server, like Perl and Haskel. SQL Server supports fewer programming languages than MySQL. MySQL has a wider range of third-party connectors and integrations.
It is correct I have explained how you can use ALL keyword. There is improvement in the question, there should be How do you select all the movies that have the highest rank score in the database? Now the solution makes sense. Sorry for the inconvenience
@@DevinAI-lf8nc Mitr you should watch English tutorial as much as possible it will increase your speaking or communication skill. Channel ka socha hu hindi wala dekhta hu aage kabhi!
@@PrimeCoding19 brother data analytics ke bare m batao kuch m Kar Rahe hu aage future to h na or job vegera k bare m Batao DA ki ,, call pe bat ho sakti h kya bro
Hello Prime Coders,
IMDB data set: drive.google.com/file/d/1SRteUqv9Q7zUj-5COqyAraIp27d8JgZm/view?usp=sharing
Question Corrections below:
1. There is improvement in the question(Q 50), there should be
How do you select all the movies that have the highest rank score in the database?
Now the solution makes sense. Sorry for the inconvenience.
Explanation of the query:
The WHERE clause uses the >= ALL operator to ensure that the rankscore of each selected movie is greater than or equal to the maximum rankscore found by the subquery.
Since the subquery returns only the maximum rank score, >= ALL effectively means rankscore >= max(rankscore), which selects movies with the highest rank score.
2. In question 18, '=NULL' should be replaced by 'IS NULL';
2nd highest or any rank based single row output question should also be included
..otherwise Very beneficial oneshot before interview..
@@SD-pz6dj After watching the complete video you will be able to solve any question...
Thanks!
@@SD-pz6dj Use offset it skips right
Your work deserves appreciation ,Can you make a video regarding questions that can be asked for HTML and CSS
Sure, stay tune!
Till now uploaded video on:-
Most asked interview questions on AL/ML PROJECT,
MERN PROJECT
Please make a video on how to explain projects and what if we have only basic project, also what if we have not done any internship what reason can we give.
Sire Prateek I will do,
Stay tune. Thanks for your suggestion.
extremely helpful. Thank you for covering all the important topics in a single video.
Thanks Yash, keep learning 🎉
Q.42) I think we can't use Having without group by.There should be simply WHERE Clause.
@@rneditz3250 use it and see the results.
@@PrimeCoding19 it doesn't work in SQL server. maybe it works in MySQL
@@PrimeCoding19 But a/c to the rule Having should be used only with groups or aggregate functions
Q42 you can use simple WHERE because If you using HAVING GROUP BY is Necessary.
Thank you from this kind of content brother 🙏
Hey Aditya, I found this video very useful. I was going through the interview experience and similar questions that you have covered in this video. Please keep uploading it is really helpful.
Thank you Anirudh, keep watching and keep supporting 🎉
Sir, You are doing great job. Your guidance is excellent and very helpful for us
Thank you it means a lot me.
Keep learning
Thank you so much for the video🎉
Thats Great
Great work brother..it helps alot
Thanks, do check interview experience also
Bro could you make video on Java interview questions too
Sure, Stay tune.
Grt guidance
Thank you it means a lot me.
Keep learning
best video on sql
Keep learning
Very helpful
Thank you it means a lot me.
Keep learning
Hello sir, could you please tell me what type of questions are asked about cloud computing for a TCS digital role?
Fundamentals, have a look on gfg.
In 48 Q use where clause after on condition
Can you make a one shot for oops as well. thank you for this video, it is very helpful.
All repeated and previous year question of oops, cn, sql, dbms basically technical question video soon.
bro for the Q42 why dont you use WHERE clause . I think it will lead to error if we use HAVING there without GROUP BY.
Please check before guessing it.
I have tried and tested on 42 question.
@@PrimeCoding19 ok bro. thanks for this one shot video it's very much helpful😊
@@PrimeCoding19 bro can i use WHERE ther or not??
@@ShiyaamsundharVetrivel please go through the question. You should return the answer in a group not in rows.
If questions states you need to return the answer in row the. Surely u can use where clause!
Good video.thank you!
Most welcome.
great video
Thank you it means a lot me.
Keep learning and supporting.
this one is really good for beginners.
Today's video will be more helpful. Do watch it!
please provide the ppt url of this video for quick revision. and also telegram link is not working
Thank you bro
Keep learning mate.
Thank you brother
Welcome, keep learning!
And we also want HR+MR ques along with ans bro
Hello Sujit already uploaded. Please check the latest video
Sir I have a doubt, in the 42Q of this video, why can't we use normal query using where clause,
select name, year from movies where year>2000;
in this also we are not using group by clause right?
tell me whether I am correct or wrong , or did I miss any condition
The question wants to return the answer in groups (not rows) without using GROUP BY.
If you use having keyword it will give answer in grouped format
A
Excellent video, it was really helpful. Could you pls share the ppt or pdf link? I couldn't find it in the description.
Hello Rahul please check the telegram group for all notes!
Sure, Stay tune
50Q Ans.
SELECT a.first_name, a.last_name
FROM actors a
WHERE a.id IN (
SELECT r.actor_id
FROM roles r
WHERE r.movie_id = (
SELECT m.id
FROM movies m
WHERE m.name = 'Schindler''s List'
)
);
Avoid using nested queries. Joins are more optimal!
Please put a vedio for excel interview questions
If you have mentioned Excel in your resume then you expect questions on excel.
Excel I will see because I don't have much knowledge about excel as its not a technical stuff.
in 42Q can't we simply write SELECT name,year FROM movies WHERE year>2000 ?? Why would one require group by here anyways, what's the catch here?
You need to return the results in a grouped manner.
@@PrimeCoding19 The results shown in your output are not grouped, neither by name nor by year.
@@aayushbisht4307 The question should be without using group by and where clause.
@@PrimeCoding19 Ohh got it now it makes sense.
Thankyou. Can you please share the db?
Database..
I will try to find or create a sql file. But for now there are multiple schemas present over net you can try that out.
hey, i watched this video , can i know any platform to practice beginners interview sql question
There are many gfg, Leetcode easy ones and sqlpractice is a type of website.
i think in 38 questions it is select year, count(movies) from table ??? but use used count(year)?
You have to use "Group By" to show the year and number of movies.
Can you explain the Q.50. I think there should be
There is improvement in the question, there should be
How do you select all the movies that have the highest rank score in the database?
Now the solution makes sense. Sorry for the inconvenience.
Explanation of the query:
The WHERE clause uses the >= ALL operator to ensure that the rankscore of each selected movie is greater than or equal to the maximum rankscore found by the subquery.
Since the subquery returns only the maximum rank score, >= ALL effectively means rankscore >= max(rankscore), which selects movies with the highest rank score.
Do we need to learn PL SQL also for TCS?
Knowledge of that will be plus point.
my major project is about secure money transfer using blockchain. how can i crack the digital interview . please help me.
Hi, you must know the basics of blockchain. They can ask you any basic question.
Try to cover all the questions related to your project. Like why did you use this technique etc.
Okay sir thanks
Next computer networking please
Yes I will upload. Note down all these pattern wise queries and revise them. This will help you in the interview
At 9:59 Can we use OFFSET without order by clause?
Yes
Please share questions pdf with us
Questions are good but data is not a good one , you could have taken any sales, finance data.
Is 42Q is wrong, I mean in the place of groupby it is where ?
No, it is written in the question that you have to write the query without using GROUP BY (means you have to print the output in GROUPs without using GROUP BY keyword) so you need to use HAVING which deals with groups . You can use 'where' if you want to deal with rows.
18 question is incorrect the correct way is
SELECT name, year, rankscore
FROM movies
WHERE rankscore IS NULL;
Thanks for pointing out, Please check the pin comment.
what is the difference between ms sql and mysql
Microsoft SQL Server supports fewer platforms than MySQL. MySQL supports more programming languages than SQL Server, like Perl and Haskel. SQL Server supports fewer programming languages than MySQL. MySQL has a wider range of third-party connectors and integrations.
where do i get ppt?
Join the telegram group and check the pinned message
send this database table for better to practice these queries........
Yes, I will please join the telegram I will notify about the database there!
38Q. we can have COUNT(movie_name) as well right, since we are already grouping it by year
For movie_name you can't use.
@@PrimeCoding19 why, since we have already grouped the data with with respect to year
@@prakharsinha4145 I will share you the db please check your query.
I guess you can't mention movies name into count.
@@PrimeCoding19 yess.. please share, or sir you yourself run that and tell if we can do it or not
Is Tcs offCampus has the section wise cutoff?
Yes, tomorrow I will upload detailed cutoff analysis and much more information. stay tune.
😢 i have excuted 2 coding questions and nill in aptitude 😢
@@Scooy-gc5xu ohho but finger cross I hope you will get Ninja role atleast.
😢 shit
where is ppt?
Join the telegram group. You can find notes in the files section.
Thank you
Bro i want pdf of these questions.. can you provide
Please join the Telegram group,
Go to files section and download the notes.
Question no 50 is incorrect
It is correct I have explained how you can use ALL keyword.
There is improvement in the question, there should be
How do you select all the movies that have the highest rank score in the database?
Now the solution makes sense. Sorry for the inconvenience
What's the point of using all it returns single value
@@PrimeCoding19best would be
Select * from movies
Where rankscore=max(rankscore)
PDF file download link
Is TCS sending mails....
For every few candidates who had shift in April. They will send the mail.
I will make an update video on this.
I think 50th question and solution aren't correct match with each other. Problem statement should be different
@@priyankawagh5217 check out the pinned comment
Pdf link
Join the telegram group and check the pinned message
please provide this slide linnk
Check in telegram group. I have uploaded!
Wrong pdf uploaded brother
Thanks for telling me,
I have uploaded an article. Please take a look now.
Sir can you send this pdf
Join the telegram group,
Go to file section you will find the pdf.
Hindi nhi aati kya aap ko ya England ka raja ho the ki English hi aav h 😂
Hindi aati ha, magar majority audience meri south se h so, English bolna padta ha
@@PrimeCoding19 to fir north valo ka kya hoga ya Esa kro koi hindi channel Bata to best for sql
@@DevinAI-lf8nc Mitr you should watch English tutorial as much as possible it will increase your speaking or communication skill.
Channel ka socha hu hindi wala dekhta hu aage kabhi!
@@PrimeCoding19 brother data analytics ke bare m batao kuch m Kar Rahe hu aage future to h na or job vegera k bare m Batao DA ki ,, call pe bat ho sakti h kya bro
What type of questions asked on artificial intelligence and machine learning, they will ask basic or advancs also
Fundamentals.
Follow up questions is depended upon your explanation.
So prepare for it, be careful when you speaking.
bro are you also MountCider, you look like so much much lol
can u please share database🥲
Check day after tomorrow it will be updated. Join the telegram group I will also notify about db.
@@PrimeCoding19 i am from E&TC background can you suggest me some tips... regarding interview and what project should i mention
Amity University Noida, G8VM+H6F, Amity Rd, Sector 125, Noida, Uttar Pradesh 201301
ANY ONE from this center ?? please contact ASAP