SQL Server/T-SQL/Subquery/Subquery From

Материал из SQL эксперт
Перейти к: навигация, поиск

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>