/SQL/Sql select inside select

Sql select inside select

Sql select inside select

SELECT
	column1,
    column2,
    column3 = (SELECT SUM(columnx) FROM tablex)
FROM table1

0

Select in select sql

SELECT column1 = (SELECT column-name FROM table-name WHERE condition),       column-names  FROM table-name WEHRE condition

0

Source: dofactory.com

Similar codes

8 votes253 views1 answer
Database backup in mysql server recovery
SQL
6 votes260 views1 answer
Wordpress change user password sql
SQL
0 vote244 views1 answer
Check mysql password with docker container magento 2
SQL
0 vote268 views1 answer
Sql where part of string match
SQL
7 votes282 views1 answer
Oracle alter sequence restart start with
SQL
0 vote288 views1 answer
Mysql insert multiple rows based on select
SQL
0 vote295 views1 answer
Install mysql on bash
SQL
0 vote291 views1 answer
For select oracle
SQL
0 vote264 views1 answer
Psql generate id in existing database
SQL
3 votes342 views4 answers
Sql interview questions
SQL

Share