SQL test

[PRC1964]

select * from table where name = 'tom'

 

[TheMonkey]

select * from table where name = 'tom'

 

[DimPrawn]

select * from table where name = 'tom'

Seems to work.

 

[Bitbucket]

select * from table where answer=correct

 

[DimPrawn]

I like this solution best:

select 1000-max(salary*1000-age)%1000 from salary

always finds the youngest person having the highest salary (as long as no one is > 1000 years old)

 

[threaded]

I like this solution best:

select 1000-max(salary*1000-age)%1000 from salary

always finds the youngest person having the highest salary (as long as no one is > 1000 years old)

nice

 

[EternalOptimist]

I like this solution best:

select 1000-max(salary*1000-age)%1000 from salary

always finds the youngest person having the highest salary (as long as no one is > 1000 years old)

it doesnt work

 

[DimPrawn]

Works for me

 

[KentPhilip]

One thing you've got to watch is that there might be another guy the same age as Tom, but on a lower salary. So I would suggest, (we'll call the table "wages"):

select * from wages
where age =

(select MIN(age) from wages
where salary = (select MAX(salary) from wages))

AND salary = (select MAX(salary) from wages)


or alternatively to avoid having to do the max salary select twice:


declare @maxsalary INT
select @maxsalary = MAX(salary) from wages

select * from wages
where age = (select MIN(age) from wages where salary = @maxsalary)
AND salary = @maxsalary

Any good?

 

[lilelvis2000]

how about:



SELECT wages.*
FROM Wages,(select max(wage) as sal from wages ) as FF
WHERE wages.age = (select min(age) from wages where wage= [FF].[Sal])
and Wages.wage = [FF].[sal]


wow! I actually wrote something that works!