faster query than this

SELECT
distinct s.employee_id,s.center_id, s.date_hired,
lastname =(select top 1 last_name from employee where
employee_id=s.employee_id ),
firstname=(select top 1 first_name from employee where
employee_id=s.employee_id )
from employee s
thanks,
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787That makes no sense to me, why don=B4t you do just
SELECT
distinct s.employee_id,s.center_id, s.date_hired,
lastname, firstname
from employee s=20
?|||What is the key of this table? Please post DDL so that we don't have to
guess. Here's my guess:
SELECT employee_id, center_id, date_hired, last_name, first_name
FROM employee AS E
WHERE last_name+','+first_name =
(SELECT MIN(last_name+','+first_name)
FROM employee
WHERE employee_id = E.employee_id) ;
David Portas
SQL Server MVP
--|||#1 Explain why is employee_id duplicated.
#2 selecting the top last_name will return unprpedictable results wihout
specifying an expression to order by.
I'm guessing that this table contains an audit of of changes to the employee
profile, so there should perhaps be a datatime column to sort and select by.
"Jose G. de Jesus Jr MCP, MCDBA" <Email me> wrote in message
news:351D0BDB-E455-437D-8A3A-B354E9C333C6@.microsoft.com...
> SELECT
> distinct s.employee_id,s.center_id, s.date_hired,
> lastname =(select top 1 last_name from employee where
> employee_id=s.employee_id ),
> firstname=(select top 1 first_name from employee where
> employee_id=s.employee_id )
> from employee s
> --
> thanks,
> --
> Jose de Jesus Jr. Mcp,Mcdba
> Data Architect
> Sykes Asia (Manila philippines)
> MCP #2324787|||normalizing a warehouse
--
thanks,
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787
"JT" wrote:

> #1 Explain why is employee_id duplicated.
> #2 selecting the top last_name will return unprpedictable results wihou
t
> specifying an expression to order by.
> I'm guessing that this table contains an audit of of changes to the employ
ee
> profile, so there should perhaps be a datatime column to sort and select b
y.
> "Jose G. de Jesus Jr MCP, MCDBA" <Email me> wrote in message
> news:351D0BDB-E455-437D-8A3A-B354E9C333C6@.microsoft.com...
>
>|||A faster query than that might be:
SELECT NULL
"Jose G. de Jesus Jr MCP, MCDBA" wrote:

> SELECT
> distinct s.employee_id,s.center_id, s.date_hired,
> lastname =(select top 1 last_name from employee where
> employee_id=s.employee_id ),
> firstname=(select top 1 first_name from employee where
> employee_id=s.employee_id )
> from employee s
> --
> thanks,
> --
> Jose de Jesus Jr. Mcp,Mcdba
> Data Architect
> Sykes Asia (Manila philippines)
> MCP #2324787