/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

4 votes344 views2 answers
Oracle drop job
SQL
0 vote341 views1 answer
Firebase sql
SQL
0 vote314 views1 answer
Show size of all tables postgres
SQL
0 vote378 views1 answer
Sql query to select even numbers
SQL
2 votes305 views3 answers
Postgres remove foreign key constraint
SQL
2 votes343 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
0 vote338 views1 answer
Login failed for user sql server
SQL
0 vote345 views1 answer
Reindex mssql table
SQL
0 vote388 views1 answer
Sqlite schema structure of a relational database
SQL
0 vote340 views1 answer
Mysql config address
SQL

Share