DATETIME SELECT SELECT INTO DATE PAD STRING DYNAMIC SQL CURSOR MONEY FORMAT PERCENT STORED PROCEDURE SQL SERVER AGENT JOB OPTIMIZATION WHILE LOOP OVER PARTITION BY UPDATE
 
 
SITE SEARCH SQLUSA.com VIDEOS
 
 
SQL E/BOOKS   WORLD, USA & SQL NEWS   FORMAT
SCRIPTS SQL 2005 SQL 2008 ARTICLES
How to use expression with the TOP clause?

Execute the following Microsoft SQL Server T-SQL script in SSMS Query Editor to find employees with the TOP 10% hourly compensation rates:

-- T-SQL SELECT with TOP expression

USE AdventureWorks

GO

 

DECLARE  @factor1 INT,

         @factor2 INT;

 

SET @factor1 = 2; SET @factor2 = 5;

 

SELECT   TOP ( @factor1 * @factor2 ) PERCENT WITH TIES Name = c.LastName + ', '+

                                                       c.FirstName,

                                                       e.Title,

                                                       Department = d.[Name],

                                                       Gender

FROM     HumanResources.Department d

         INNER JOIN HumanResources.EmployeeDepartmentHistory edh

           ON edh.DepartmentID = d.DepartmentID

              AND edh.EndDate IS NULL

         INNER JOIN HumanResources.Employee e

           ON edh.EmployeeID = e.EmployeeID

         INNER JOIN Person.Contact c

           ON e.ContactID = c.ContactID

ORDER BY Name DESC

 

GO

/*

Name                    Title                         Department  Gender

Zwilling, Michael       Production Technician - WC60  Production  M

Zimmerman, Kimberly     Production Technician - WC10  Production  F

Zabokritski, Eugene     Production Technician - WC30  Production  M

Yukish, Gary            Production Technician - WC40  Production  M

Yu, Nuan                Production Technician - WC50  Production  M

Young, Garrett          Production Technician - WC30  Production  M

Yalovsky, David         Production Technician - WC30  Production  M

.....

*/


 

Exam Prep 70-461
SQL 2016 DESIGN & PROGRAMMING
 
 
 
DATETIME SELECT SELECT INTO DATE PAD STRING DYNAMIC SQL CURSOR MONEY FORMAT PERCENT STORED PROCEDURE SQL SERVER AGENT JOB OPTIMIZATION WHILE LOOP OVER PARTITION BY UPDATE