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.
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# 👍
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.
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,
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.
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.
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.
@@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.
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.
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.
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
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
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
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...
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.
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.
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.
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.
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. :)
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 :)
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.
@kudvenkat Thanks for the series, this is still helpful. just one thing, can you please revisit the video on 18:3318: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.
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.
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.
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 :)
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.
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.
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?
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
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 )
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 :)
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.
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?
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 :)
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 ?
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.
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
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.
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.
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
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?
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
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.
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.
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.
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...
+Ankaj Jha Here is a solution for even: Select * from MyTable where MyNumberColumn % 2 == 0 here is for odd: Select * from MyTable where MyNumberColumn % 2 == 1 MyTable is the table you want to select from, and MyNumberColumn is the column with numbers, from which you want to filter either odd or even numbers. Hope it helped
Dear Sir, nobody can explain SQL better than you in this world. I have highest regards for you for ever
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.
ruclips.net/video/GNbsxeo_hOA/видео.html
the greatest teacher ever. these video series are better than read books
ruclips.net/video/GNbsxeo_hOA/видео.html
Knowledge never gets old. Thank you
What a wonderful service you are doing to the community! You make things sound easy!!!!!
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# 👍
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.
Please make vedios on power bi, msbi
"Mumabi" xD
Seriously though you explain SQL very well. I will be following the series from here on forth.
Thanks alot man.
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,
ruclips.net/video/GNbsxeo_hOA/видео.html
Learned more in this 21 minute video than you can get in 400-page books
Crystal clear again. Thank you very much!
WE: You are the best teacher ever!
YOU: Is that possible?
WE: Absolutely!
ruclips.net/video/GNbsxeo_hOA/видео.html
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.
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.
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.
@@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.
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.
sir with due respect,, we are greatfull to you..i never seen anywhere this kind of crisp and clear explaination,, its simply amazing
Wow!! This series is super powerfull and comprehensive. Appreciate the great job, sir
simply awsome!! love the way you make it simple and explain very well. wish you have videos on SSIS, SSRS and Tableau.
Ma'am please provide me the link 🔗 of SSRS tutorial if you found. Please 🙏
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.
Hello Rekha - You can find a few SQL Server interview questions in the following playlist.
ruclips.net/p/PL6n9fhu94yhXcztdLO7i6mdyaegC8CJwR
i want to say thank you for teaching us in a detailed manner .
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.
Some people are gifted at explaining things. He is one of them.
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
never seen such a brief and well explained SQL turorial on youtube by the way it referred from CODEBASICS
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
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
this is very very helpful.I appreciate your effort..God bless you
i am new to learning sql and want to get into BI. this is really helpful.
ruclips.net/video/GNbsxeo_hOA/видео.html
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...
Very Helpful Video !!! Helped me to learn well for the examination. Thank You !!!
Sir You are the best teacher...Really..
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.
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.
ruclips.net/video/GNbsxeo_hOA/видео.html
if names were repeated two times then it will sort them is ascending order
who's still refering this in 2023.?
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.
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.
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. :)
Hello Venkat.
Thanks for your videos they are great!!!
Venkat, you and your videos are fabulous my friend!!!!! Simply awesome.
ruclips.net/video/GNbsxeo_hOA/видео.html
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 :)
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.
Awesome short video. Everything I needed for daily small tasks.
ruclips.net/video/GNbsxeo_hOA/видео.html
@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.
Thank you Sir. Nice explanation.
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.
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.
ruclips.net/video/GNbsxeo_hOA/видео.html
is that possible?
absolutely!
well with your manner of telling everything is possible ;p great tutorials thanks
ruclips.net/video/GNbsxeo_hOA/видео.html
thank you, you're the best.
Hi @Venkat just a question how can one use the tables being used in each of the tutorial video,
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 :)
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.
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.
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?
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
Joh < Jos, that's why the sorted by the age didn't change
Age should be in the ascending order.. but in video the age is in descending order
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 )
Thank you very much, these tutorials are brilliant.
ruclips.net/video/GNbsxeo_hOA/видео.html
Thanks bro if you like video please subscribe to ruclips.net/video/GNbsxeo_hOA/видео.html channel name technology friends thanks
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 :)
the best ever tutorial ;)
ruclips.net/video/GNbsxeo_hOA/видео.html
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.
Hello Venkat. Could you please share the table details from your videos
It's most important videos
Brilliant..!! Thanks Venkat Very Helpfull :)
ruclips.net/video/GNbsxeo_hOA/видео.html
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?
his videos are really help full..but yes...I was confused too..
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 :)
ya..
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.
Thanks a lot sir for your knowledge sharing.. thanks
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 ?
Thanks for the instructions, I needed that!
ruclips.net/video/GNbsxeo_hOA/видео.html
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?
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.
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
Simple. Thank you!
Awesome as usual!
Man is this helpful!
ruclips.net/video/GNbsxeo_hOA/видео.html
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.
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.
Great info
I'm guessing the LIKE '[MST%]' is not working in the later version of Sqlserver. I try it here it's not working
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
Distinct removes duplicates across 2 columns which means that those values will not shown together
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?
Very helpful tutorials.
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
ruclips.net/video/GNbsxeo_hOA/видео.html
Thx You.
18:25 are you sure that age ascending order sorted correctly ? :S
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.
Mehmet Yener Yilmaz you are right
it's mistake at 18:32
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
kudvenkat: I made a mistake on purpose that you might learn better :P
How many hours will it take to complete the " SQL Server tutorials for the beginners"?
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.
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.
great sir....
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?
You are next to god..
Hi sir how can we select all table name from database through querry?
@kudvenkat , How Can I prompt user input in SQL Server Mngmt Studio??
@kudvenkat..pls answer
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...
hello venkat , but age is not in ascending order plz check
Dear sir, query got executed successfully but data hasn't came, couldn't figure it out...
Nice !!!
Please tell how to insert records into a table from multiple tables
age is not coming in ascending order after sorting n your video on 18:37 please have a look Sir
thanks for this tutorial
ruclips.net/video/GNbsxeo_hOA/видео.html
Bro use this query for joining two conditions instead writing or ...
select * from person2 where city in('london','DC') and age>30
ruclips.net/video/GNbsxeo_hOA/видео.html
name query not getting could you pls help me starting like pst
Thank You Sir. :)
ruclips.net/video/GNbsxeo_hOA/видео.html
thank you
"Select top 2 * from tblEmp order by 1 desc" Explain this sir why and how 1 can be used after order by
were can i get this database, i mean .bak file?
brilliant
Dear Sir,
I want Retrieve Even or Odd number from table
*** HOW ???
Please provide me solution for the question
thanks
+Ankaj Jha Here is a solution for even:
Select * from MyTable where MyNumberColumn % 2 == 0
here is for odd:
Select * from MyTable where MyNumberColumn % 2 == 1
MyTable is the table you want to select from, and MyNumberColumn is the column with numbers, from which you want to filter either odd or even numbers.
Hope it helped
Select * from MyTable where MyNumberColumn % 2 = 0
Nice video but at 16:44 you typed "Mumbai" wrong, leading it to only show the people from London