Select statement in sql server - Part 10

[@dcgadagprasannakumar4347]

Dear Sir, nobody can explain SQL better than you in this world. I have highest regards for you for ever

[@nikajavakhishvili158]

the greatest teacher ever. these video series are better than read books

[@srinathreddymukkamalla3691]

kzbin.info/www/bejne/fX_FpKubpMSbhaM

[@romeror1945]

Knowledge never gets old. Thank you

[@brindhaganesan3580]

What a wonderful service you are doing to the community! You make things sound easy!!!!!

[@scottsaccenti]

Learned more in this 21 minute video than you can get in 400-page books

[@luvlycan]

I'm a VBA developer, and the way you are teaching these codes, I can easily relate. You are best instructor I've seen so far. Thank you so much for your time and efforts in creating these tutorial videos.

[@Csharp-video-tutorialsBlogspot]

Hello Lucky - Thank you very much for the feedback. Means a lot. I have included all the sql tutorial videos, slides and text articles in sequence on the following page. Hope you will find it handy. www.pragimtech.com/courses/sql-server-tutorial-for-beginners/ When you have some time, can you please leave your rating and valuable feedback on the REVIEWS tab. It really helps us. Thank you. Good luck and all the very best with everything you are doing.

[@luvlycan]

@@Csharp-video-tutorialsBlogspot Sure brother... as soon as I will awake tomorrow... the 1st thing I'm gonna do is write the review for you. hope you and your family is safe.. and remain safe.

[@altonmario467]

Sir I thank you so much. Really you are a great teacher. I know nothing in sql but really i am understanding clearly the concept when you teach. Thanking you so much Sir.

[@William_Cronje]

"Mumabi" xD Seriously though you explain SQL very well. I will be following the series from here on forth. Thanks alot man.

[@Trzbne]

Crystal clear again. Thank you very much! WE: You are the best teacher ever! YOU: Is that possible? WE: Absolutely!

[@srinathreddymukkamalla3691]

kzbin.info/www/bejne/fX_FpKubpMSbhaM

[@lakshmanreddy8817]

sir with due respect,, we are greatfull to you..i never seen anywhere this kind of crisp and clear explaination,, its simply amazing

[@saiteja552]

who's still refering this in 2023.?

[@pandit-jee-bihar]

Some people are gifted at explaining things. He is one of them.

[@isHhedirisooriya]

Wow!! This series is super powerfull and comprehensive. Appreciate the great job, sir

[@suzansuzan2779]

really amazing, i heard a lot about you but unfortunately didn't watch your videos, now i really regret. You are the best teacher, best material explanation. Thank you sooooo much, I wish you much success.

[@radovanslavkovsky2778]

Hey Venkat, I am taking this lessons of yours / 10th of 68 atm / and I ´ve feel I should say thanks for all these lessons.. Very nice of you that you made it free of charge.. and with this all support of yours. Sending best regards from Slovakia,

[@srinathreddymukkamalla3691]

kzbin.info/www/bejne/fX_FpKubpMSbhaM

[@nishagupta9520]

i want to say thank you for teaching us in a detailed manner .

[@anilpardeshi2948]

Dear sir first of all thank you for giving much time to us for creating awesome tutorial. Some people can not afford the tutation fees .so for them it is very usefull to learn and go ahead . Bascially you doing

[@rinkupatel77]

simply awsome!! love the way you make it simple and explain very well. wish you have videos on SSIS, SSRS and Tableau.

[@shubhenduinfotech5992]

Ma'am please provide me the link 🔗 of SSRS tutorial if you found. Please 🙏

[@Csharp-video-tutorialsBlogspot]

In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you.

[@srinathreddymukkamalla3691]

kzbin.info/www/bejne/fX_FpKubpMSbhaM

[@REKHAKUMARI-bt5vj]

I saw a few videos and really liked the way you have explained it. It would be really helpful if you could also help us with real-time interview questions.

[@Csharp-video-tutorialsBlogspot]

Hello Rekha - You can find a few SQL Server interview questions in the following playlist. kzbin.info/aero/PL6n9fhu94yhXcztdLO7i6mdyaegC8CJwR

[@ashrafanwar1144]

never seen such a brief and well explained SQL turorial on youtube by the way it referred from CODEBASICS

[@rinkupatel77]

i am new to learning sql and want to get into BI. this is really helpful.

[@srinathreddymukkamalla3691]

kzbin.info/www/bejne/fX_FpKubpMSbhaM

[@stupiidiot]

Hi saw ur video part 10 as that is the only thing i needed to lear right now and want to say thank you so very much. It was very helpful.

[@aswathichandran3050]

Venkat, Your videos are awesome. Thank you so much. Can you pleses upload all the ppts alone somewhere. This will help us a quick recap day before interview. Going through all videos just before interview is not possible. Thanks

[@Csharp-video-tutorialsBlogspot]

Hello Dear Aswathi, The image version of the slides are available on my blog at no cost. csharp-video-tutorials.blogspot.com However, if you want to download all the original PPTs, you can order them from the following link. Hope you will find them useful. www.pragimtech.com/download_kudvenkat_slides.aspx Goof Luck Venkat

[@rathod3029]

this is very very helpful.I appreciate your effort..God bless you

[@rabiaimran9027]

Sir You are the best teacher...Really..

[@tzvikrabinowitz5446]

Hello Venkat. Thanks for your videos they are great!!!

[@MahendranathMahi821]

Very Helpful Video !!! Helped me to learn well for the examination. Thank You !!!

[@TheReedm5]

Venkat, you and your videos are fabulous my friend!!!!! Simply awesome.

[@srinathreddymukkamalla3691]

kzbin.info/www/bejne/fX_FpKubpMSbhaM

[@heemabhatt8397]

thanks for sharing this videos. its really helpful but please include another interview question explanation: how to fetch 2nd highest age from table? its really tricky one...

[@jordannash4420]

Awseome video series. The query he used at 16:29 I wrote differently it still brings up the same result he wanted. I showed it as a another way of doing it. SELECT * FROM tblPerson WHERE City In('Mumbai','London') AND Age > 25 Any SQL Server expert who feels my statement is bad should not hesitate to question what I wrote, thanks.

[@انامسلموكفى]

petite remarque : sql part 10 .18:33 =====> select * from tblPersom order by Name DESC , Age ASC as result : josh and john are not similar as you "said" but it would like you explain if they are similiar thank youuu for your effort you re the best teacher for me sql and c# 👍

[@carelesshx]

Hi Venkat! Thanks very much for these videos, they're really helpful. Just thought it was worth mentioning that using the != operator in a query doesn't return NULL values in the selected column. It appears that NULLs require special handling in SQL and I hope this gets covered in a future video :)

[@Tyuvfdhb]

Awesome short video. Everything I needed for daily small tasks.

[@srinathreddymukkamalla3691]

kzbin.info/www/bejne/fX_FpKubpMSbhaM

[@mageraldes]

First of all, great videos, very usefuls and very well organizeds. Keep on make this good work. But this one in particular you have a bug on the AND OR operators. You have city='Mumabi' instead of Mumbai and the table as only one record with age > 25 so that particular query allways return only one row.

[@shobhitpathak3461]

@kudvenkat Thanks for the series, this is still helpful. just one thing, can you please revisit the video on 18:33 18:35 this seems not correct. because first of all both of the names are different also they are not sorted . Else the details shared in the video are good.

[@vishaljhaveri6176]

Thank you Sir. Nice explanation.

[@gregorym7598]

18:33 - Josh is repeated twice...Venkat what are you talking about... 18:35 - so their ages are sorted in ascending order...Venkat what are you talking about, twice xD

[@willgraham2061]

Joh < Jos, that's why the sorted by the age didn't change

[@sahildhar6805]

Age should be in the ascending order.. but in video the age is in descending order

[@romdhum]

Hi Vankut, You are simply awesome. Your ways of presentation connect to anyone with little or no knowledge of the technology you are teaching. I wish you all the best for your continuous support to the beginners like me. God bless you. :)

[@tomaszmalesa4043]

Hi, great job! but funny mistake @18:20. I wondered why this AGE column isn't realy in ASC order like You said. The answer is: there aren't Josh and Josh but Josh and John, it takes me some time to realize it :)

[@Rakinroww]

is that possible? absolutely! well with your manner of telling everything is possible ;p great tutorials thanks

[@srinathreddymukkamalla3691]

kzbin.info/www/bejne/fX_FpKubpMSbhaM

[@Infector88]

Hello Venkat. Your tutorials are awesome, keep up the good work! But I would like to point a small mistake; when you are talking about sorting asc and desc, there is JOSH and JOHN, not Josh x2. Following that, "age asc" is not applied in this particular example, since we don't have any of the names repeated.

[@benparker9313]

Thanks for that, was watching in small window and just took him saying that the names were the same for granted and couldn't figure out why the 29 was above the 20 if they were supposedly in ascending order.

[@srinathreddymukkamalla3691]

kzbin.info/www/bejne/fX_FpKubpMSbhaM

[@salmanzakir1997]

if names were repeated two times then it will sort them is ascending order

[@sumanhappy]

Hi Venkat, Real big thanks for videos they are really helpful. can you cover examples on selection the 2ND highest salary from tables using triggers and also concatenating the date according to persons date of birth i.e. (if we enter person's DOB,The present age of the person with days should be returned )

[@lawnsky]

Please recheck, its Josh and John that is why order by age is inactive in the scenario. Would the name have been same then the age would have displayed in ascending manner. Its okay it was a human error.

[@pandit-jee-bihar]

One of the drawbacks of working on multiple databases is that you tend to forget the queries and need revision once in a while. Different NoSQL dbs with their own query language make it even worse and then there are also proprietary ones.

[@JaswantSingh-go8ey]

It's most important videos

[@Csharp-video-tutorialsBlogspot]

Thank you very much for taking time to give feedback. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video. For email alerts, when new videos are uploaded, you may subscribe to my channel.

[@mohansaivelagapudi929]

Please make vedios on power bi, msbi

[@Csharp-video-tutorialsBlogspot]

Hi Rajiv, if you have the rows matching with what you have in the where clause, then you should get data. Can you please share your query and the data in one or two rows of your table that you are querying. Without looking at the table and the query I wouldn't be able to tell what's wrong. Good Luck.

[@motwanimani]

for the last example. eldest employee. "Top" is not a good idea as there could be two persons of age = 29. We should use. select * from tblperson where age = (select max(age) from tblperson) Overall. your videos are pretty good.

[@TheAnoj123]

Hello Venkat...Thanks for the great video tutorial series..I like your way of teaching...really I became your follower..I am practicing your all video tutorials step by step..waiting for your more tutorials ...once again thanks lots for your very great and useful tutorials....keep it up :)

[@LarsRyeJeppesen]

Thank you very much, these tutorials are brilliant.

[@srinathreddymukkamalla3691]

kzbin.info/www/bejne/fX_FpKubpMSbhaM

[@srinathreddymukkamalla3691]

Thanks bro if you like video please subscribe to kzbin.info/www/bejne/fX_FpKubpMSbhaM channel name technology friends thanks

[@SuperEvoken]

thank you, you're the best.

[@pramodmaurya6610]

Thanks a lot sir for your knowledge sharing.. thanks

[@GeantaConstantinCosmin]

the best ever tutorial ;)

[@srinathreddymukkamalla3691]

kzbin.info/www/bejne/fX_FpKubpMSbhaM

[@Csharp-video-tutorialsBlogspot]

Hi Rajiv, escape the single quote with another single quote. So, your query will be something like this - Select * from TableName where ColumnName in ('40'' Standard Dry','20'' Standard Dry'). Hope this helps. If you want to receive email alerts, when new videos are uploaded, please feel free to subscribe to my youtube channel. May I ask you for a favour. I want these tutorials to be helpful for as many people as possible. Please share with your friends and family.

[@Ayubajbnabi]

Awesome as usual!

[@KranthiPasupuleti-u6i]

Great info

[@sumans2647]

Brilliant..!! Thanks Venkat Very Helpfull :)

[@srinathreddymukkamalla3691]

kzbin.info/www/bejne/fX_FpKubpMSbhaM

[@marsrover2754]

Hi @Venkat just a question how can one use the tables being used in each of the tutorial video,

[@pranay6243]

Hello Venkat, I have a question in this part 10 video you have given an example where we can sort on two columns. I don't think so this will work if we look into the output. I think practically its not possible?. Could you please confirm on this? Thanks in Advance.

[@srinathreddymukkamalla3691]

kzbin.info/www/bejne/fX_FpKubpMSbhaM

[@300barzz]

Very helpful tutorials.

[@rohitmirania941]

Hello Venkat. Could you please share the table details from your videos

[@dieselboats7886]

Simple. Thank you!

[@GauravSingh-xz4bo]

At 18:37... I have a question on the example you gave for ORDER BY clause where NAME is DESC and AGE is ASC. Shouldn't it be Josh Aaged 20 would have been at row 4 instead at 5?

[@Jstar141957]

Thanks for the instructions, I needed that!

[@srinathreddymukkamalla3691]

kzbin.info/www/bejne/fX_FpKubpMSbhaM

[@srinukindia]

Hi Venkat, I have a doubt here. Could u tell me... among order by and top (say top 10) which one has the priority. I mean will the rows be ordered first and then top 10 are picked up. Or will top 10 be picked up and then ordered. Imagine the data in table is in disordered randomly.

[@tzvikrabinowitz5446]

Hello Venkat., I've notice you said something on using order by so that you can you use it on more than one column, i.e. name desc,age asc. but in the example I saw there was different input so I am not sure it truly explained I mean to the part close to the end in the 18th min. aprox. What do you think?

[@piyasidey2117]

his videos are really help full..but yes...I was confused too..

[@splashQo]

I think he meant it like, that you can order items by more arguments. For instance, first you order them by NAME, but, if there are more items with same name, than they will be ordered by second argument, in this case AGE... I hope we are speaking about same thing :)

[@piyasidey2117]

ya..

[@jemarchanjr]

I agree that the problem was that the names were not the same. One was Josh, and the other was John. therefore the age field didn't matter.

[@swatikamath5859]

Hi Venkat, Thank you for posting such amazing videos. I have a small doubt though, When we specify any character in the [ ] are they case sensitive?

[@devexpost8508]

For starters, it depends on how your db server was set up in the Server Properties, General, Server Collation. If you have a scheme like "SQL_Latin1_General_CP1_CI_AS" then it is: (CP1) Code Page 1252 characters, and searches are Case Insensitive and Accent Sensitive.

[@vijayalakshmi-wk2mv]

hi venkat, u have done a great job thanks for the vedios. can u send me the download link of the database you used for the vedio's. it would be more helpfull for me

[@srinathreddymukkamalla3691]

kzbin.info/www/bejne/fX_FpKubpMSbhaM

[@pannappagarikarthik5293]

Hi Venkat , By using IN operator we can able to get Records at time multiple Integer columns values. But What about character columns. I m not able to get the character columns (varchar data type columns) When I am going using IN Operator. If we have an any another operator, Plzzzz clarify me.

[@mehmetyeneryilmaz2579]

18:25 are you sure that age ascending order sorted correctly ? :S

[@pv4988]

Ya... Its not. He said josh is repeated twice and the age is given in ascending, but it is not it is josh and john which are two different names. Before adding age ascending and after the result is same.

[@omprakash1453]

Mehmet Yener Yilmaz you are right it's mistake at 18:32

[@parmsingh3822]

it's not a mistake because he sort the name desc order and that last 2 name is start with J but the next letter is different like JOSH and JOHN

[@gregorym7598]

kudvenkat: I made a mistake on purpose that you might learn better :P

[@indusekhark8677]

Bro use this query for joining two conditions instead writing or ... select * from person2 where city in('london','DC') and age>30

[@srinathreddymukkamalla3691]

kzbin.info/www/bejne/fX_FpKubpMSbhaM

[@selimreza1540]

great sir....

[@ashishakshantal1868]

How can we add multiple records for same column ? I mean, if we have a new column that we created in our table that has 13 records , and now how to add the values for the new column in all the rows ?

[@pradeepsavaji6523]

You are next to god..

[@blak_dice5514]

Man is this helpful!

[@srinathreddymukkamalla3691]

kzbin.info/www/bejne/fX_FpKubpMSbhaM

[@dankemo3169]

Thx You.

[@michaeltaye8033]

Nice !!!

[@yombomahomet1845]

thanks for this tutorial

[@srinathreddymukkamalla3691]

kzbin.info/www/bejne/fX_FpKubpMSbhaM

[@rajivlamichhane]

Dear sir, how could we give in command if the data type is something like 20' standard dry or any data has a ' sign? for example i gave one command like this, select * from shipment data where container type name in (40' Standard Dry, 20' Standard Dry) will not be executed while i tried... please help me

[@pratibharana1146]

I did not understand one thing in the last - that if more than one person is having same highest salary, how is top 1 * giving the highest salary details?

[@shashikant2011]

Please tell how to insert records into a table from multiple tables

[@venkykrishnan]

"Select top 2 * from tblEmp order by 1 desc" Explain this sir why and how 1 can be used after order by

[@GautamThakur]

thank you

[@sayedubaidh7969]

Hi Venkat, I have a question in DISTINCT. Here is how my table looks like[ID Name City] [1 ubaidh pune] [2 hajra Mumbai ] [3 Misbah Goa] [4 pune pune] Now if i fire this query "select distinct name,city from table1" i get the following result [hajra Mumbai] [Misbah Goa] [pune pune] [ubaidh pune]. But in the video you said that DISTINCT on multiple columns will give value distinct across the 2 columns but in the 3rd record you can see i have [pune pune] in both columns. Can u please explain

[@egyknight]

Distinct removes duplicates across 2 columns which means that those values will not shown together

[@REKHAKUMARI-bt5vj]

How many hours will it take to complete the " SQL Server tutorials for the beginners"?

[@Csharp-video-tutorialsBlogspot]

Hi Rekha - Around 27 hours. I can confidently say if you are comfortable with the concepts discussed in these videos you will be able to achieve most of the things in SQL with a lot of ease.

[@henriquecardoso5544]

Nice video but at 16:44 you typed "Mumbai" wrong, leading it to only show the people from London

[@nishagupta9520]

hello venkat , but age is not in ascending order plz check

[@gitanjalipadhihari1]

Thank You Sir. :)

[@srinathreddymukkamalla3691]

kzbin.info/www/bejne/fX_FpKubpMSbhaM

[@evermovie461]

brilliant

[@muhammadshifa4886]

Hi sir how can we select all table name from database through querry?

[@akshaybanaye]

Is there any difference between: SELECT * FROM table_person WHERE Name NOT LIKE '[MST]%' And SELECT * FROM table_person WHERE Name LIKE '[^MST]%' @ 15.07 minutes.

[@varunguleria5960]

@kudvenkat , How Can I prompt user input in SQL Server Mngmt Studio??

[@varunguleria5960]

@kudvenkat..pls answer

[@javiervara9478]

HI. I've unable to follow the tutorials starting at Part 10. The tutorial is great but there is no way I can get to continue. Any suggestions?

[@blackmediapodcast]

Awesome! channel, I need your help. I have a web form that surfaces data based on a phone number from my Microsoft SQL DB 2008. I would like for people to have to put their first name in and their phone number before any data surfaces on the screen??? Please help or suggest a resource...

[@rahuldobale4876]

age is not coming in ascending order after sorting n your video on 18:37 please have a look Sir

[@rajivlamichhane]

Dear sir, query got executed successfully but data hasn't came, couldn't figure it out...

[@mesfinareda]

What is Schema? (dbo.)

[@sanjitpatil1576]

were can i get this database, i mean .bak file?

[@ashaashu411]

name query not getting could you pls help me starting like pst

[@adeyemiakanfe7641]

I'm guessing the LIKE '[MST%]' is not working in the later version of Sqlserver. I try it here it's not working

[@2Cor10five]

Try putting the % outside the brackets