datetime century date into pad dynamic cursor money percent sp job isnumeric isdate over update
SQLUSA.com
SQL 2008 GRAND SLAM ON 49 CD
FREE TRIAL  CLICK HERE TO ORDER  SEARCH
SQL Server Training SQL 2005 Scripts SQL 2008 Articles
SQL JOBS News Format Developer
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

.....

*/


 

Order SQL 2008 GRAND SLAM Today!
SQLUSA.com Home Page
SQL Server Training at www.sqlusa.com.
Microsoft SQL Server 2012 Training Videos at www.sqlusa.com.
SQL Server 2008 Video Training at www.sqlusa.com.
SQL Server 2005 Training Videos at www.sqlusa.com.
Accounting
Administrative
Advertising
Arts
Architecture
Banking
Business Intelligence
Career Jobs
Celebrity
Computer
Consulting
Customer Service
Education
Engineering
Entertainment
Entry Level
Executive
Federal
Finance
Government
Hardware
Healthcare
Hospital
Human Resources
Information Technology
Insurance
Internet
Job Openings
Laboratory
Law Enforcement
Legal
Logistics
Manufacturing
Marketing
Medical
Military
Nursing
Pharmaceutical
Physician
Public Relations
Publishing
Real Estate
Restaurant
Retail
Sales
Social Media
Software
SQL Database
Telecomm
Therapist
Training
Transportation
Truck Driver
Travel
Web
Work from Home

FREE SS SQL / BI OLAP Short Videos on YOUTUBE.com

Microsoft Community Contributor 2011 Microsoft Community Contributor 2012

Search SQLUSA FREE SQL Server Articles & FREE T-SQL Scripts

JOIN US ON TWITTER

Copyright 2005-2012, SMI Corp. All Rights Reserved.

SQL Server 2012 is a program product of Microsoft Corporation.
SQL Server 2008 is a program product of Microsoft Corporation.
SQL Server 2005 is a program product of Microsoft Corporation.
SQL Server 2000 is a program product of Microsoft Corporation.