Pages

Sunday, April 6, 2008

Try this

Sql 1

select
max(numberField)
from
TableName
where
salary not in (
select
max(numberField)
from TableName
);

Sql 2
select
field1,.....,fieldn
from
TableName alias1
where
2 = (
select
count(*)
from
TableName alias2
where
alias1.field1< alias2.field1
)
;