Transact SQL 101 - Lesson 03_02_SQL.txt

(0 KB) Pobierz

--TOP
SELECT TOP(10) *
FROM saleslt.product
ORDER BY listprice

--TOP PERCENT EXAMPLE
SELECT TOP(5) PERCENT *
FROM saleslt.product
ORDER BY listprice

SELECT TOP(3) PERCENT WITH TIES *
FROM saleslt.product
ORDER BY listprice

SELECT TOP(3) WITH TIES *
FROM saleslt.product
ORDER BY listprice

Plik z chomika:

Inne pliki z tego folderu:

Transact SQL 101 - Lesson 01 - Video 02 - Using SQL Server Management Studio.wmv (22544 KB)
Transact SQL 101 - Lesson 02 - Video 01 - Understanding and Using Data Types.wmv (12605 KB)
Transact SQL 101 - Lesson 01- Video 03 - Installing the Sample Database.wmv (9839 KB)
Transact SQL 101 - Lesson 01 - Video 01 - Introduction to SQL.wmv (2938 KB)
Transact SQL 101 - Lesson 03 - Video 01 - Retrieving Data Using The Select Clause.wmv (10047 KB)

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin