Skip to main content

SubQuery in MySQL

By
A subquery is a query inside another query or it is a nested query which is embedded within the WHERE clause.

Subqueries can be used with the SELECT, INSERT, UPDATE, and DELETE statements along with the operators like =, <, >, >=, <=, IN, BETWEEN etc.

A subquery must be enclosed within parentheses. It can have only one column in the SELECT clause unless multiple columns are in the main query for the subquery to compare its selected columns.

For example:

We have two tables as below:

1)tbl_employees
eid name address email mobile
1 Ryan Ktm ryan@gmail.com 9874512663
2 Sunaina Lagankhel s@gmail.com 98745256325
3 Preeti Budhanagar p@gmail.com 987412321

2) tbl_salaries
sid eid salary
1 1 20000
2 2 10000
3 3 15000


Now you want to know names of those employees who earn more than 12000

So you need to use SQL as below:

SELECT * FROM tbl_employees WHERE eid in (SELECT eid FROM tbl_salaries WHERE salary > 12000)

Labels

Labels:

Comments

Post a Comment

Popular posts from this blog

MySQL Connection

By
Connection with MySQL Database Before accessing database, you must create a connection to the database Syntax: mysql_connect(servername,username,password); where, servername specifies the server to connect to. Default value is “localhost” username specifies the username to log in with. Default value is the name of the user that owns the server process. To connect offline we use username “root”. password specifies the password to log in with. Default is “” Code : Creating connection to the database and selecting the required database <?php $con = mysql_connect(“localhost”,”root”,”"); if (!$con) { die(‘Could not connect: ‘ . mysql_error()); } else{ mysql_select_db(“test”, $con) }; ?> Here, we have store connection in a variable called $con and trap error using die function. Closing connection The connection will be closed automatically when the script ends. To close the connection before, use the mysql_close() function: <?php $con = mysql_conne...
Post a Comment
Read more

Join in MySQL

By
Join clause is used to combine rows from two or more tables depending upon common field between them. There are different kinds of Joins. The most common and useful Join is Inner Join. Inner Join: It will return all rows from multiple tables where the condition is met.
Post a Comment
Read more

Div and span

By
Div: Div <div> tag is that it divides the HTML document into sections. Proper usage of the <div> tag is fundamental to good HTML coding, the <div> tag is one of the most powerful tools available to a web developer. Span: Span <span> is  in-line level elements, they only span across small amounts of content, typically words or phrases. For example: a <span> tag might be used to make a word red in color or to give it an underline.
Post a Comment
Read more