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
)
;
No comments:
Post a Comment