Reply to: SQL test

[Bitbucket]

There are no ethnic minorities and sue the only female is on the lowest salary , what sort of company is this DP? Shut it down immediately!

Of course most companies will now have many immigrant workers and as most of them would be about 19 and earning the same rate of 5 per day , in the real world it would be an easy task

Name Age Salary
Abdul 18 5
Sanjay 19 5
Mona 20 5
Rital 17 5
Dave 56 200
Mike 62 250

And of course after management had seen the results then you would get

Name Age Salary
Abdul 18 5
Sanjay 19 5
Mona 20 5
Rital 17 5
Pakra 21 5
Ramish 22 5

[VectraMan]

Same but I'd use x86-64 Assembly with bubble sort to find the answer...

Entered direct into a keypad in octal? I assume you know all the opcodes and wouldn't have to resort to a high level assembly language like some namby pamby youngster.

[DimPrawn]

I'd ftp the data to India and get some poor sods on $5/hr to find the answer.

[AtW]

I'd do: SELECT * from table
Then I'd use C++ to find the answer.

Same but I'd use x86-64 Assembly with bubble sort to find the answer...

[VectraMan]

I'd do:

SELECT * from table

Then I'd use C++ to find the answer.

[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!

[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?

[DimPrawn]

Works for me

[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

[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

[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)

[Bitbucket]

select * from table where answer=correct

[DimPrawn]

select * from table where name = 'tom'

Seems to work.

[TheMonkey]

select * from table where name = 'tom'

[PRC1964]

select * from table where name = 'tom'