SQL Server/T-SQL/Subquery/Subquery From
Write a query as part of the FROM clause
<source lang="sql">
1> CREATE TABLE employee (emp_no INTEGER NOT NULL, 2> emp_fname CHAR(20) NOT NULL, 3> emp_lname CHAR(20) NOT NULL, 4> dept_no CHAR(4) NULL) 5> 6> insert into employee values(1, "Matthew", "Smith", "d3") 7> insert into employee values(2, "Ann", "Jones", "d3") 8> insert into employee values(3, "John", "Barrimore","d1") 9> insert into employee values(4, "James", "James", "d2") 10> insert into employee values(5, "Elsa", "Bertoni", "d2") 11> insert into employee values(6, "Elke", "Hansel", "d2") 12> insert into employee values(7, "Sybill", "Moser", "d1") 13> 14> select * from employee 15> GO (1 rows affected) (1 rows affected) (1 rows affected) (1 rows affected) (1 rows affected) (1 rows affected) (1 rows affected) emp_no emp_fname emp_lname dept_no
-------------------- -------------------- -------
1 Matthew Smith d3 2 Ann Jones d3 3 John Barrimore d1 4 James James d2 5 Elsa Bertoni d2 6 Elke Hansel d2 7 Sybill Moser d1
(7 rows affected) 1> -- Write a query as part of the FROM clause 2> 3> SELECT emp_fname, emp_lname 4> FROM (SELECT * FROM employee WHERE emp_no >= 1) AS empno_10000 5> GO emp_fname emp_lname
--------------------
Matthew Smith Ann Jones John Barrimore James James Elsa Bertoni Elke Hansel Sybill Moser (7 rows affected) 1> 2> drop table employee 3> GO
</source>