MySql IF statements (and a sub query!)

MySql IF statements (and a sub query!)

Март 11, 2011

Ever wanted to know what situation a mysql if statement would call for? Well here it is! We also go into group by, round, left join, and do a sub query as well.

 111  8

23,249 просмотров

comments powered by Disqus
9:39 SQL Server interview questions :- What are Sub Query and Co-related Queries ?

SQL Server interview questions :- What are Sub Query and Co-related Queries ?

For more such videos visit http://www.questpond.com
For more such videos subscribe https://www.youtube.com/questpondvideos?sub_confirmation=1

See our other Step by Step video series below :-
Learn SQL Server Step by Step http://tinyurl.com/ja4zmwu
Learn Data Science in 1 hour :- https://tinyurl.com/y5o7qbau
Learn Power BI Step by Step:- https://tinyurl.com/y6thhkxw
Learn MSBI Step by Step in 32 hours:- https://goo.gl/TTpFZN
Learn Tableau step by step :- https://tinyurl.com/kh6ojyo
Learn Angular tutorial step by step https://tinyurl.com/ycd9j895
Learn MVC Core step by step :- http://tinyurl.com/y9jt3wkv
Learn C# Step by Step https://goo.gl/FNlqn3
Learn Design Pattern Step by Step https://goo.gl/eJdn0m
Learn Azure Step by Step :- https://tinyurl.com/y6fmrech
Learn SharePoint Step by Step in 8 hours:- https://goo.gl/XQKHeP


Preparing for C# /.NET interviews start here http://www.youtube.com/watch?v=gaDn-sVLj8Q

In this video we will try to understand what are SQL server sub queries, co-related queries and how they differ from each other.

We are also distributing a 100 page Ebook "Sql Server Interview Question and Answers". If you want this ebook please share this video in your facebook/twitter/linkedin account and email us on [email protected] with the shared link and we will email you the PDF.

 1724  85

296,198 просмотров

5:25 Mysql - Conditional IF()

Mysql - Conditional IF()

Mysql — Conditional IF()

 5  0

2,711 просмотров

6:49 More TextWrangler Regex

More TextWrangler Regex

 57  2

8,114 просмотров

14:12 How to Install MySQL Server on Windows

How to Install MySQL Server on Windows

We will learn how to install mysql server on Windows which completes the installation series. After completing this video you will be able to run PHP code using Apache and connect to MYSQL databases from your localhost under Windows.

`````````````````````````````````````````````````````````````````````````````````````````````
Hey guys, I'm now using Patreon to share improved and updated video lesson material. For a small fee you can access all the downloadable files from this lesson (source code, icons & graphics, cheat sheets) and everything else included in the video from the Patreon page. Additionally, you will get access to ALL Clever Techie videos in HD format with no ads. Thank you so much for supporting Clever Techie :)

Download this video's files here:
https://www.patreon.com/posts/20810817

( This unlock includes access to ALL Clever Techie channel videos in HD 1080p quality format with all video ads removed! )

`````````````````````````````````````````````````````````````````````````````````````````````
Correction: "if you haven't watched Apache and PHP video, watch it first"

Final video in the series for installing and configuring the latest version of PHP, Apache and MYSQL on Windows 7.

mysql.php code:

http://clevertechie.com/mysql.txt

PS: It's best to learn how to install mysql server yourself on Windows, rather than using packages like wamp, xamp etc...because it gives you full control over your environment.

``````````````````````````````````````````````````````````````````````````````````````````````

( Website ) https://clevertechie.com — PHP, JavaScript, Wordpress, CSS, and HTML tutorials in video and text format with cool looking graphics and diagrams.

( YouTube Channel ) https://www.youtube.com/c/CleverTechieTube

( Google Plus ) https://goo.gl/J71p6f — clever techie video tutorials.

( Facebook ) https://www.facebook.com/CleverTechie/

( Twitter ) https://twitter.com/theclevertechie

``````````````````````````````````````````````````````````````````````````````````````````````

 718  61

271,140 просмотров

20:2 MySQL Stored Procedures and Functions (Topic #5: MySQL course from JPassion.com)

MySQL Stored Procedures and Functions (Topic #5: MySQL course from JPassion.com)

This is a partial presentation. For complete presentation, hands-on lab document, and sample apps, please go to http://jpassion.com and acquire full subscription.

 256  16

78,884 просмотров

5:50 Tutoriel php-mysql (Les jointures,INNER JOIN,LEFT JOIN,RIGHT JOIN) | By NewDzign

Tutoriel php-mysql (Les jointures,INNER JOIN,LEFT JOIN,RIGHT JOIN) | By NewDzign

►►►►►►► Merci de lire la description ◄◄◄◄◄◄◄

1) — Le site : http://www.newdzign.org

2) — La page facebook : http://goo.gl/vaWvXB

3) — Pour plus de videos abonne toi : http://goo.gl/wgfzdM

4) -Clique sur j'aime ça me fait plaisire.

5) -L'autre chaîne : http://goo.gl/u0KMlN

 42  5

8,874 просмотров

4:12 PL/SQL tutorial 9: IF THEN ELSE (IF-ELSE) Statement in PL/SQL by Manish Sharma

PL/SQL tutorial 9: IF THEN ELSE (IF-ELSE) Statement in PL/SQL by Manish Sharma

3rd tutorial in the series explaining IF-THEN-ELSE statement in Oracle PL/SQL with Example. Enjoy
————————————————————————————————————
►►►LINKS◄◄◄
Blog : http://bit.ly/if-then-else
Previous Tutorial
► IF THEN Statement https://youtu.be/IWvuFD6eD30
————————————————————————————————————-
►►►Let's Get Free Uber Cab◄◄◄
Use Referral Code UberRebellionRider and get $20 free for your first ride.
————————————————————————————————————-
►►►Help Me In Getting A Job◄◄◄

►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company
Thanks

————————————————————————————————————-
►Make sure you SUBSCRIBE and be the 1st one to see my videos!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on

https://twitter.com/rebellionrider
https://www.facebook.com/imthebhardwaj
http://instagram.com/rebellionrider
https://plus.google.com/ Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
http://rebellionrider.tumblr.com/
http://www.pinterest.com/rebellionrider/

You can also Email me at
for E-mail address please check About section


Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos

This is Manish from RebellionRider.com
♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS

 718  3

73,299 просмотров

7:48 SQL Server Queries Part 5 - CASE Expressions

SQL Server Queries Part 5 - CASE Expressions

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

By Andrew Gould

https://www.wiseowl.co.uk — Learn how to use CASE expressions in queries in Microsoft SQL Server. This video teaches you how to test conditions using a CASE expression and provide different answers based on whether the conditions are met.

A written version of this tutorial can be found at:
https://www.wiseowl.co.uk/blog/s330/case-when.htm

You can download the script to create the Movies database used in this video at the following link:
https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip

You can see the range of resources and courses we offer in SQL Server here:
https://www.wiseowl.co.uk/sql/

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!

 744  8

130,003 просмотров

39:1 Conditional statements and loops in R

Conditional statements and loops in R

Video tutorial on using ifelse, if and while conditional statements in R, as well as for loops, and the apply family of functions.
Please view in HD (cog in bottom right corner).
Download R script here: https://drive.google.com/open?id=1JR7H30pBWBBg-iENth4lIJNycjb-yKwq

 57  0

4,556 просмотров

10:51 MySQL - Blocos Condicionais IF - THEN - ELSE e CASE - 38

MySQL - Blocos Condicionais IF - THEN - ELSE e CASE - 38

MySQL — Blocos Condicionais IF / THEN / ELSE e CASE — 38

Contribua com a Bóson Treinamentos!:
Clube de Contribuições do Catarse:
https://www.catarse.me/bosontreinamentos

Outras formas de contribuição:
http://www.bosontreinamentos.com.br/contribuir/

Por Fábio dos Reis
Bóson Treinamentos: http://www.bosontreinamentos.com.br
Facebook: https://www.facebook.com/bosontreinamentos/
Pinterest: https://br.pinterest.com/bosontreina/
Twitter: https://twitter.com/bosontreina
Instagram: https://www.instagram.com/bosontreinamentos/
LInkedin: https://www.linkedin.com/in/fábio-dos-reis-06ba192a/

Outros projetos do autor:
Diário do Naturalista: http://www.diariodonaturalista.com.br

 249  0

12,347 просмотров