Second part of STRING functions. Explained in best way as always. Greetings from Poland!
@Csharp-video-tutorialsBlogspot11 жыл бұрын
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.
@adduxe3 жыл бұрын
I believe you can go GROUP BY EmailDomain instead teacher. P.S. I was just offered a job yesterday after watching only 22 of your SQL videos! The extra notes you included in the video were actually included in the interview! (Whew!) THANK YOU SO MUCH!!!!!! Hat's off to you teacher!
@tejamarneni3 жыл бұрын
@adduxe You cannot use alias in a Group by clause.
@lucylee945710 жыл бұрын
Very useful videos. It is so kind of you filming all these informative and educational videos. Thank you very much.
@Trzbne6 жыл бұрын
5 days without watching your videos... Hard and long week. Already here, enjoying your lesson :-) Thank you very much!
@trytofindareasonwhy2 ай бұрын
Oh man that last part is tough. kudos to any who fully understand this topic
@rasikadhanapala53543 жыл бұрын
Excellent teaching. Thank you very much 👌
@vigneshvikey93922 жыл бұрын
Very useful videos, excellent teaching thank-you so much sir keep going and upload more videos 💐💐
@caothanhlong75775 жыл бұрын
Wow very easy to understand! Thank you so much.
@maheshgirish6071 Жыл бұрын
Thank you so much Venkat sir great teaching
@programmeseekho27956 жыл бұрын
Thank You Sir Very helpful Video..Very Nice Sir
@aliazad11185 жыл бұрын
As usual perfect. Best tutorial
@hrushinathkale13723 жыл бұрын
Very Nice video sir. thank you so much for this series.
@nolimit1676 жыл бұрын
Thanks for the instructional videos! I've learned a ton from you Venkat. One question that i have is that , wouldn't the result still be the same if the last expression/argument in substring was left out? for example, substring(email,charindex('@',email)) would have been the same as substring(email,charindex('@',email), len(email)-charindex('@',email)?
@sohanyennu37507 жыл бұрын
Such a useful concept explained very simply...I really appreciate your efforts!!
@navinkrishnan94194 жыл бұрын
thank you!
@vkgupta3 жыл бұрын
In your last example, Can I use Alias name as EmailDomain After group by?
@AVD07211 жыл бұрын
It is very helpful
@jagadeeshperuri25273 жыл бұрын
Nice explanation with short time sequence...is there any possibility for ASP.NET MVC tutorials
@eldadnevo17428 жыл бұрын
Perfect videos, can you upload the sample database?
@ashokbachina76467 жыл бұрын
Venkat..you are awesome!!!
@BoxerDogs5 жыл бұрын
Good explanation. Thank you for posting this.
@satyaprakashsingh164410 жыл бұрын
thanks very much.... its very useful, i am studying from this tutorial
@afifkhaja8 жыл бұрын
Very well explained. Thanks!
@devarakondasankararao38025 жыл бұрын
Great explanation Sir
@diegomarin55988 жыл бұрын
Thank you so much! it really helps a lot!!
@prashantx193 жыл бұрын
How can I separate the full_name column into the separate columns EX- I have a table with concatenated full name and I want to display that into separate columns like first_name, middle_name, last_name Prashant M sonawane Amit S patil
@oksanaveretiuk16538 жыл бұрын
Many thanks!
@suprajacheppala22945 жыл бұрын
what is the syntax to get before @ for an email for whole table
@kaushikbhadani11 жыл бұрын
very very nice...Thank you..
@rupeshthangella20594 жыл бұрын
Hi Sir, Can you make video regarding Partitions in Sql?
@flaeski5 жыл бұрын
Muito boa explicação, parabéns!!!
@piyasidey21178 жыл бұрын
Thank You Very Much Sir...
@piyushamohanty26719 жыл бұрын
Hello Sir, its really very video and use full However, there is one question from my end..... Here you've used all the domain names of same length so you've done as it is. Let me know what will be the query when the domain names are of different length in the column? I really need your help sir...
@ASHOKSHARMA-yn4gl7 жыл бұрын
Great information, thank you so much :) Ashok
@asmitapatil80873 жыл бұрын
Do you have any session on synonyms in sql
@palcolon7 жыл бұрын
Thank you my good sir
@richardmirabelli5128 жыл бұрын
Is it possible to use LEFT, RIGHT AND SUBSTRING in CASE expressions. For example, I want to say (Case when left(column1,5) = left(column2,5) then column 3 else null end). Is this doable? If not are there alternatives to this? Thanks
@nimishajain88608 жыл бұрын
thank u so much for explaining :)
@Csharp-video-tutorialsBlogspot8 жыл бұрын
+Nimisha Jain You are very welcome. I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you kzbin.infoplaylists?view=1&sort=dd If you need DVDs or to download all the videos for offline viewing please visit www.pragimtech.com/kudvenkat_dvd.aspx Slides and Text Version of the videos can be found on my blog csharp-video-tutorials.blogspot.com Tips to effectively use my youtube channel. kzbin.info/www/bejne/r2ibYYCtnb5qZtU If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. kzbin.info If you like these videos, please click on the THUMBS UP button below the video. May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them. Good Luck Venkat
@pravallikakiran91986 жыл бұрын
While Explaining third argument of SUBSTRING() you have used total length of string - till where we do not require. But my doubt is while defining the Substring() the second argument itself specifies the start position and so the third argument could be total length of the length. select SUBSTRING('sara@aaaa.com',charindex('@','sara@aaaa.com')+1,len('sara@aaaa.com')) could give the expedted reply na? why to use (-)minus and all? I'm sorry i'm very much new to this IT field so just out of confusion/curiosity i'm posting my doubt.
@sokkimchhoin862111 жыл бұрын
thank so much
@sivaboyidi99396 жыл бұрын
Hello Mr.Venkat. Could you please explain the internal query mechanism(query execution process). I've a query like this, and i would like to know the process of it... select t1.Id,t1.Name,t1.Email,t1.Gender,t1.Languages,t2.name as Name,t3.Name as Name,t4.Name as Name from [Table1] t1 join [table2] t2 on t1.a=t2.Id join [table3] t3 on t1.b=t3.Id join [table4] t4 on t1.c=t4.Id Thanks in advance.....
@dunnymusic10 жыл бұрын
very helpful thanks
@anilgarlapati89988 жыл бұрын
Thank you
@aamirhalai49076 жыл бұрын
As said in video what are the other ways to get final shown output??
@hasinmahjabeen72524 жыл бұрын
Cool!
@pradeepdhamija5694 жыл бұрын
at time location 10:02 if you just hardcode 100 instead of 7 then I got the same results. I even tested if it added 93 spaces. But it did not. Is there a issue with that idea which I do not know. Doing this will make it faster?
@Raghav543216 жыл бұрын
Hi Venkat could you please explain Substring function with negative (-1) parameter value like select substring(@string,-1,5) etc.
@stutitehri99310 жыл бұрын
very important functions
@gauravverma65339 жыл бұрын
Nice tutorial
@harshadgurav92817 жыл бұрын
What to do if strong contain many same characters and if i want to calculate under of 3rd or 4rth character?
@redietalemayehu6404 жыл бұрын
or we can easily use this query to get the last email id and then group them up. What do you think? Select RIGHT(Email,Len(Email) - CharIndex('@',Email)), Count(*) From tblEmployee Group by RIGHT(Email,Len(Email) - CharIndex('@',Email))
@birdsdepartment4 жыл бұрын
Hello Sir How are you? Hope ou are fine. Please tell me how to use alias "Total" in a query such as (english+maths) as Total,(Total/MaxMarks)*100 as Percentage.
@ravindrababuravi54952 жыл бұрын
Explained very well, thank you. Can you please explain how we can divide a value\text into columns if it consist of multiple underscores? like abc_123h_xyz, 2345x_TZ_5546.
@wenjiegan5978 жыл бұрын
Hi, Thanks for ur tutorial! I have a question. Group by cannot use the alias name in the same query? But Order by is allowed to use?
@sunilkumar-hy4yt4 жыл бұрын
Hi, As per SQL Execution order Group By Executes first then Select, so it cannot pick the alias in Group By. Where as Order By executes after Select so alias can be used in order by.
@davinder1910singh6 жыл бұрын
Suppose I have one String as "ABC EFG", now I want to pick the value using RIGHT function till first Space which comes. How Can I do that?
@harshag13353 жыл бұрын
Sir how do i display a name which is starting from 6th position (right end) and i want to display only 4 characters..
@thuythanhhainh69322 жыл бұрын
Hi everyone, Can I ask a question regards to the minute 14:00 please? When I tried to write the Group By statement like: Group By EmailDomain -> system stated I had an error because of the invalid column name "EmailDomain". I don't understand why that's it? Can anybody help me explain it pleaseeeeeee.
@chanchalarya9832 жыл бұрын
sir how can I add $ in sum(total_amt) plz tell
@gregorym75984 жыл бұрын
How and why is possible for example Sara to with select CHARINDEX('@', Email)-2, Email from tblEmployee be 2 and LEN of her Email is 11 here...so 11-2=9........................... AND select (LEN(Email) - CHARINDEX('@', Email)-2) from tblEmployee be 5 so 11-2=5 I got it and know what happened, but can you explain this situation why SQL Server look like (11 - 4) - 2 = 5 when is obviously and logically 11 - 2 = 9 because CHARINDEX('@', Email)-2 giving output 9 If you have time and understand what I'm asking explain, even if I realized what happened here, explain why is this happening like this...when is particularly like I said 11-2=9
@sanasafinaz85495 жыл бұрын
how to get middle name from full name . Like in full name we have 'XYZ' and we have to extract z middle name
@newaribabu5 жыл бұрын
How can I apply the same syntax on ORACLE SQL Developers? This one is in MS SQL server and I'm using ORACLE SQL SERVER. Oracle doesn't support or recognize CHARINDEX command in Oracle. Anyone please?
@technologyforalleasyway1353 жыл бұрын
hello sir, how to get a digit from right side after 4 digit, like from a number 101456678, want to get 4 but using right, please help
@TiengtrungXiXi8 жыл бұрын
Can you guys tell me how to get the name of emails ?
@72sh7 жыл бұрын
Like 'google' from 'google.com' ? If that is ur question then SELECT SUBSTRING( EMAILADDRESS, CHARINDEX('@', EMAILADDRESS) + 1, LEN(EMAILADDRESS) - (CHARINDEX('@', EMAILADDRESS)+ 2) - LEN(CHARINDEX('.', EMAILADDRESS)) ) FROM [Person].[EmailAddress]
@MixTapeYT17 жыл бұрын
SELECT SUBSTRING(Email,0,CHARINDEX('@',Email)) from tblPerson
@gregorym75984 жыл бұрын
Venk, I was playing little with this and look what I found: select SUBSTRING(Email, CHARINDEX('@',Email)-5, (LEN(Email) - CHARINDEX('@', Email)-2)) Name from tblEmployee group by SUBSTRING(Email,CHARINDEX('@', Email)-5, (LEN(Email) - CHARINDEX('@', Email)-2)) Well isn't it interesting...
@SaikatBhadury7 жыл бұрын
Declare @Name nvarchar(50) Set @Name='John Deo' Declare @FirstLetter nvarchar(1) Declare @SecondLetter nvarchar(1) Set @FirstLetter=LEFT(@Name,1) Set @SecondLetter=SUBSTRING(@Name,CHARINDEX(' ',@Name)+1,1) SELECT 'Short Name = '+UPPER(@FirstLetter)+'.'+UPPER(@SecondLetter) AS ShortName How To Do Like @Name='John Deo Something' As J.D.S Output I Use It.. Thanks Sir
Sir If i need to find the names in the email i mean left characters of email(ex:ravi@gmail.com I need ravi instead of domain name) what will be the expression.
@ivangrgic42817 жыл бұрын
select Left(email,charindex('@',Email)-1) fromTBLemployee -> for left string
@neyon78243 ай бұрын
FirstName - Jesus LastName - Manual Scavenger
@MrFaheemalig3 жыл бұрын
DECLARE @full_path VARCHAR(500)= 'C:\Users\Michael\Documents\Microsoft SQL Server\MyScript.sql'; we want to pull "MyScript.sql " this one from this full path but I need dynamically can you please answer this
@AnandKumar-dc2bf Жыл бұрын
Its better if you remove such very old videos and keep only new ones atlest 5 years old ...
@callmecheese46964 жыл бұрын
6:53 “we want to start the position sex”
@codingstream5724 жыл бұрын
is he from mycodeschool....?
@arshianazneen20123 жыл бұрын
In the length part subtracting full email - starting till @ should b done to get the string from bbb.com but here we r subtracting 11-7 ie full string - starting from @