/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 votes296 views5 answers
Alter table add column with default value
SQL
0 vote317 views1 answer
My sql data file extention
SQL
0 vote293 views1 answer
Mysql drop multiple tables at once
SQL
1 vote325 views1 answer
How to fetch alternate records from two tables
SQL
1 vote330 views3 answers
Postgresql get difference between two dates
SQL
0 vote309 views1 answer
Connect to nginx server mysql remotly
SQL
0 vote285 views1 answer
Sql developer format sql
SQL
1 vote315 views1 answer
Sql server select rows by distinct column
SQL
2 votes341 views1 answer
Oracle insert or update
SQL
0 vote297 views1 answer
How to install mysql without admin rights
SQL

Share