7, SQL Basic collation (sub-query)

Sub-query

(used for querying between two tables, etc.)

The query inside the parentheses can only display information for one column

Select *from haha where age in (

Select MAX (age) from haha where bumen = ' sales Department '

) and Bumen in (

Select Bumen from haha group by bumen have COUNT (*) >5)

---Practice: The information of the first, the person according to the age from small to large

Select top 3 *from haha where code not in (

Select Top 5 code from haha order by age)

ORDER BY age

-----------Paging--------------

Select top 5*from haha where code not in (select Top ten code from haha)

----------a table How many pages can be divided by the specified number of entries (5)----------

Select Ceiling (COUNT (*)/5.0) from haha

(Cannot use 5 integral type, to prevent auto default to int type)

7, SQL Basic collation (sub-query)