@27:12 The reason why you were able to select a result set without error at first, but then second-time SQLServer threw error was, you highlighted the top select statement and executed it. :-) Good video though.
@@chandanikumari5332 I used to work in IT industry. I used to work as an Incident Handler. My job was not technical. I am now waiting for retirement. Now I am not working, so I started learning for fun and pass time. I was amazed by all the knowledge and aptitude shown by the different IT engineers. I am a matriculate. I have come to the conclusion that today on YOU TUBE you can find so many free courses and if you are determined and hard working, you can acquire a very handy skill set free and then get some sort of diploma. Having a diploma (this is for those of us, who did not go to the university) and real practical knowledge, you can get a job in the IT industry as a junior and then work your way up. All the best, work hard and be determined. You will succeed.
Case expression is the correct terminology. Pointing out if you are taking tests the terminology matters, they can try and trick you! Predicate, clause, statement, expression, search argument, try to make sure you understand the differences is my point.
Angular, MVC core starting 16.07.20, Every Thursday at 9 PM. Syllabus explained in the video if needed the syllabus do email at questpond@questpond.com. If Interested share this video on your FB, Twitter, and Linkedin and avail today's training free. th-cam.com/video/MblRRqld1fg/w-d-xo.html
First I want to complement you with this video, it it clearly build up and takes the viewer through the steps in an ordered manner. I am using it to freshen up my SQL knowledge for a test coming up. Secondly I would like present you with an improvement for practice 23. The query you present is not compatible when products have the same cost. When two products share the same value nothing is returned. Using the 'SELECT TOP' statement make it so the query is not dependent on the hardcoded COUNT(*) statement. When using the code below you can play with the integer after SELECT DISTINCT TOP SELECT a.ProductName FROM tblProduct a WHERE a.ProductCost = (SELECT TOP 1 ProductCost FROM (SELECT DISTINCT TOP 3 b.ProductCost FROM tblProduct b ORDER BY b.ProductCost DESC) tblProduct ORDER BY ProductCost) I know their are obviously more ways to things nonetheless I wanted to point this out. I like you vids, keep up the good work
hi bro did you find Practice SQL file then please provide me the link here...i think it was channel's strategy to attract and get personal details from viewers...
Tqu.. So much sir.. Ur teaching skill ultimate and even also how can i say to thanks I feel very happy and even also ur explanation is very good.. Even single of doubts was b clear for all.. So tqu so much sir.. For ur previous time... I love it.. Ur explanation.. Thank 🌹🌹🌹 you Sir...
Thank you so much sir for this wonderful Sql tutorial. Your teaching is very clear and straight to the point. I also enrolled and practicing your msbi course. Thanks a lot for your dedication and hard work to teach us.
For Practice SQL example 2 anyone can help...? So far my query : select p.ProductName, sum(productcost) as TotalSales, count(t.Productid_fk) as [Count] from tblProduct p full outer join tblTotalSales t on p.ProductId= t.Productid_fk group by ProductName the problem is with totalsales for count 0 its showing ProductCost as I am taking sum of productcost how to solve this sir..please help me @Questpond
Great stuff...there r many other ways of 2nd highest..like nested query or key words like top,limit,rownum or by rank...that should be also there in video other than correlation query.
Thank you very much sir!!Its really really help full for us who r new learners for SQL and in future also please share ur knowledge videos with us thanks in advance and once again thanyou very much sir!!
Hello Dear Instructor How can I get Your E-book Interview books? I have already shared the videos on face book that you give but still i can not Get your free practice interview files on thank You Sir
i had try to my best. . .. . but i did not get it him. . . and also send it mail but this domain are not found it. . . . please help me how to get this share file . .
SQL Step by Step - th-cam.com/video/uGlfP9o7kmY/w-d-xo.html
SQL Server Joins : th-cam.com/video/KTvYHEntvn8/w-d-xo.html
20+ SQL Server Interview Questions : th-cam.com/video/SEdAF8mSKS4/w-d-xo.html
Software Architecture Interview Questions : th-cam.com/video/AtTgcbLOqMM/w-d-xo.html
20 MSBI Interview Questions : th-cam.com/video/Nw_sHEKnOUE/w-d-xo.html
10+ Power BI Interview Questions : th-cam.com/video/Cozc9WNBRt4/w-d-xo.html
Angular Step by Step Tutorial for Beginners : th-cam.com/video/-9VcW7MBDs8/w-d-xo.html
25 Angular Interview Questions : th-cam.com/video/-jeoyDJDsSM/w-d-xo.html
35 Important JavaScript Interview Questions : th-cam.com/video/Zb4dPi7CANU/w-d-xo.html
30 Important C# Interview Questions : th-cam.com/video/BKynEBPqiIM/w-d-xo.html
25+ OOPS Interview Questions : th-cam.com/video/u99wAoBjDvQ/w-d-xo.html
25 Important ASP.NET Interview Questions : th-cam.com/video/pXmMdmJUC0g/w-d-xo.html
20 MySQL Interview Questions : th-cam.com/video/9hfjC-BpY20/w-d-xo.html
20 PHP Interview Questions : th-cam.com/video/1bpNSynUrl8/w-d-xo.html
5 MSBI Interview Questions : th-cam.com/video/5E815aXAwYQ/w-d-xo.html
TY SIR.
Sir can you share a video on Pattern matching in c sharp
sir where is the plsql i cannot find it
@27:12 The reason why you were able to select a result set without error at first, but then second-time SQLServer threw error was, you highlighted the top select statement and executed it. :-) Good video though.
lu li ada f
I am a beginner, excellent tutorial. Complete with great depth. Thank you very much
U not look like beginners
@@chandanikumari5332 I used to work in IT industry. I used to work as an Incident Handler. My job was not technical. I am now waiting for retirement. Now I am not working, so I started learning for fun and pass time. I was amazed by all the knowledge and aptitude shown by the different IT engineers. I am a matriculate. I have come to the conclusion that today on YOU TUBE you can find so many free courses and if you are determined and hard working, you can acquire a very handy skill set free and then get some sort of diploma. Having a diploma (this is for those of us, who did not go to the university) and real practical knowledge, you can get a job in the IT industry as a junior and then work your way up. All the best, work hard and be determined. You will succeed.
One the best tutorial I have ever seen thank you so much for your knowledge sir I really appreciate 👍👍👍👍👍
the best SQL video i have seen on youtube
thanks a lot
Case expression is the correct terminology. Pointing out if you are taking tests the terminology matters, they can try and trick you! Predicate, clause, statement, expression, search argument, try to make sure you understand the differences is my point.
This is more helpful for beginner Thanks so much
YES INDEED.
Very useful video. Thank you so much!
Excellent course.. Learnt lot of things.. Thank you Questpond.
Super teaching with good examples
Excellent teaching style! Kudo to you, sir!
thanks for the video. where can i find the dataset for practice these queries
Angular, MVC core starting 16.07.20, Every Thursday at 9 PM. Syllabus explained in the video if needed the syllabus do email at questpond@questpond.com.
If Interested share this video on your FB, Twitter, and Linkedin and avail today's training free.
th-cam.com/video/MblRRqld1fg/w-d-xo.html
Amazing tutorial, quite straight and great examples.
i guess it's quite randomly asking but do anybody know of a good site to stream newly released series online ?
THANK YOU SIR,
FOR TEACHINING. :-)
GOOD UNDERSDENDING THIS VIDEO CONCEPT FOR SQL,
First I want to complement you with this video, it it clearly build up and takes the viewer through the steps in an ordered manner. I am using it to freshen up my SQL knowledge for a test coming up.
Secondly I would like present you with an improvement for practice 23. The query you present is not compatible when products have the same cost. When two products share the same value nothing is returned.
Using the 'SELECT TOP' statement make it so the query is not dependent on the hardcoded COUNT(*) statement.
When using the code below you can play with the integer after SELECT DISTINCT TOP
SELECT a.ProductName FROM tblProduct a
WHERE a.ProductCost =
(SELECT TOP 1 ProductCost FROM
(SELECT DISTINCT TOP 3 b.ProductCost
FROM tblProduct b
ORDER BY b.ProductCost DESC)
tblProduct
ORDER BY ProductCost)
I know their are obviously more ways to things nonetheless I wanted to point this out. I like you vids, keep up the good work
amazing!
Thanks for the video. Please i am not able to get the practice sql database. Can some one help me?
Thank you so much sir...its really useful
i really thank you verrrrrrryyyyyyyyy much from the bottom of my heart u gave me a clear understanding about the concept of all the video u did
Good explanation the only thing that is annoying is those red underlines errors. I wished he had removed those errors.
I AGREE.
Thank you! Merci! Obrigada!
Thanks a lot sir !
He is the best.
I am unable to find the PracticeSql file, please provide a link
hi bro did you find Practice SQL file then please provide me the link here...i think it was channel's strategy to attract and get personal details from viewers...
quality of training very neat nd clear.... excellent
Really helpful🙌🏻,!!!
very good session sir....thank you
Please can you share such lab for oracle database students as well
Where first u create all schema and tables and then we test these scenarios 1 by 1
Thanks for sharing this, greetings from Mexico.
Thanks and do visit www.questpond.com/learn-sql-server-step-by-step/cid9
Tqu..
So much sir..
Ur teaching skill ultimate and even also how can i say to thanks I feel very happy and even also ur explanation is very good.. Even single of doubts was b clear for all.. So tqu so much sir.. For ur previous time... I love it.. Ur explanation..
Thank 🌹🌹🌹 you Sir...
Very clear and precise explanation.thanku
thanks you. it is completed teaching and lab.
Any video for microservices?
Thank you
Your course is easy to understand and structured well. Thanks!
Thanks and do visit www.questpond.com/learn-sql-server-step-by-step/cid9
Sounds good, kinda excited to learn this!
Thank you so much sir. 🥰
Best tutorial for Beginners
Excellent course. really learned a lot. Thank you very much
Thanks and do visit www.questpond.com/learn-sql-server-step-by-step/cid9
Can someone help from where can we download the sql file ?
Plz help for How to get this all database tables sqlpractice , this can't saw in website.
It is awesome but please i can't get that t1, t2 in self join and correlated querry .
That is why this t1 and t2??
Thanks , video clears my concepts.
It's alias name of customer table there is two alias name for same table bcoz it's self join
Good questions
Thank you so much sir for this wonderful Sql tutorial. Your teaching is very clear and straight to the point. I also enrolled and practicing your msbi course. Thanks a lot for your dedication and hard work to teach us.
I couldn't find the link, pls share
Super duper teaching with good examples ....
Very very useful sir :-)
Thank u so much :-)
How to save 3d matrix in database?
For Practice SQL example 2 anyone can help...?
So far my query :
select p.ProductName, sum(productcost) as TotalSales, count(t.Productid_fk) as [Count]
from tblProduct p
full outer join
tblTotalSales t
on p.ProductId= t.Productid_fk
group by ProductName
the problem is with totalsales for count 0 its showing ProductCost as I am taking sum of productcost how to solve this sir..please help me @Questpond
Superb video tutorial
Thanks and do visit www.questpond.com/learn-sql-server-step-by-step/cid9
i had an exam tomorrow! thanks alot!!!
Thanks and do visit www.questpond.com/learn-sql-server-step-by-step/cid9
Amazing, Thank you very much.
Thanks and do visit www.questpond.com/learn-sql-server-step-by-step/cid9
Excellent work.
shubu watch this as many times as you can
I COULDNT AGREE LESS.
Sir, which IDE u r using?..Please reaply..
Kindly share PracticeSql , unable to find
Thank you so much sir... Pls keep on ur service..
Thanks you so much very useful video
A lot of thanks sir... Now I am able to work on SQL.
can u plz upload the database that u have created so that we can refer your DB ?
Did u got that one
this is awesome!
Thanks and do visit www.questpond.com/learn-sql-server-step-by-step/cid9
Query Design Editor Only Show CrOSS JOIN on every table why Not Others Join?
Good explanation
Hi where I can find the practice.sql file?
Time saving one ! ..thanks :-)
Thanks and do visit www.questpond.com/learn-sql-server-step-by-step/cid9
Can anyone share the example file(InvoiceDB) here?
well done go ahead sir
Thanku amazing
Thanks and do visit www.questpond.com/learn-sql-server-step-by-step/cid9
Thnx sir for this video 👍👍
Thanks and do visit www.questpond.com/learn-sql-server-step-by-step/cid9
I really thank you very much. . . . i need one help how to get the share file . . .
i had try but i did not get him. . . .please me. . .
Kindly share database creation queries
Hello Meenakshi you can send email to get the same.
Great stuff...there r many other ways of 2nd highest..like nested query or key words like top,limit,rownum or by rank...that should be also there in video other than correlation query.
hello sir could you provide me the sql sheet?
Thank you very much sir!!Its really really help full for us who r new learners for SQL and in future also please share ur knowledge videos with us thanks in advance and once again thanyou very much sir!!
Hello Dear Instructor How can I get Your E-book Interview books? I have already shared the videos on face book that you give but still i can not Get your free practice interview files on
thank You Sir
Good explanation Sir 👏
Where I will get the practice db sql
Send us an email for the same.
does anyone has the link to download the file to create the database for practicing?
I cant get it too
Thank you it helped a lot
Awesome
Thanks and do visit www.questpond.com/learn-sql-server-step-by-step/cid9
@@questpondvideos You teach the best.
Can anybody say who to write aa query to display of those students who joined on the same date
You have to select date
Good tutorial. Thanks.
Sir telugu lo kuda chepadaniki try cheyandi sir please
Where do i get the practiceSQl file ?
send email at questpond@questpond.com
practise.sql is missing
Any body here can pls let me know if learning from this video is enough for software testers for interview purpose?
IT SURE IS.
@@shravansrinivasan4982 okay, Thanks.
sir where is practice file
Waleikoum Salaam brother
sir hindi me bhi btane ki kripa kren👍👍👍
Anyone know where i can get hold of the database?
Spending 1hr worthy of reading 4hrs about basic and some complex queries which can build up on...
Anyone with the link for the file?
Send email at questpond@questpond.com to get the practice file.
Could please share that file
34:00
Nice One
Thanks and do visit www.questpond.com/learn-sql-server-step-by-step/cid9
Your display screen is so tiny
I think I'm going to watch that video that teaches me brain surgery in an hour
i had try to my best. . .. . but i did not get it him. . . and also send it mail but this domain are not found it. . . . please help me how to get this share file . .
please try to send to questpond@questpond.com
SQL install ni ho raha kya karu?
Whats the error
I didn't get that what u told to use
Please send pdf
Follow the instruction given in the video and send email to us to get PDF.
Beginners for Sql can try this.