SQL Syntax Help Group By type query

I don't have access to check this at the moment but does this put you on the right track?

DECLARE @temp TABLE
  (
     loanid INT,
     amount INT
  )

INSERT INTO @temp
SELECT loanid,
       amount
FROM   loans
WHERE  Isnull(relseq, 0) = 1
UNION
SELECT loanid,
       Max(amount)
FROM   loans
WHERE  relseq IS NULL
GROUP  BY relid

SELECT loanid
FROM   @temp 

Select allOpen in new window

SELECT LoadId
FROM (
    SELECT
        LoadId,    
        ROW_NUMBER() OVER (PARTITION BY RelID ORDER BY RelSeq DESC, Amount DESC) AS row_num
    FROM dbo.tablename
) AS subquery1
WHERE
    row_num = 1

Scott pretty close but this is taking also the records that don't have a grouped count > 1 for RelID but on there own.  For example:

Example Set of data:

LoanId      PoolId      RelSeq      RelID      Amount
7030      1123      NULL      1123-1      4468547.79
7031      1123      NULL      1123-2      2724929.25
7032      1123      NULL      1123-3      2675334.52
7033      1123      NULL      1123-1      2665100.77
7034      1123      NULL      1123-5      2277303.22
7035      1123      NULL      1123-6      2185009.11
7036      1123      NULL      1123-7      1020178.69
7037      1123      NULL      1123-1      859755.98
7038      1123      NULL      1123-9      849044.17
7039      1123      NULL      1123-10      676773.52
7040      1123      NULL      1123-11      512084.90
7041      1123      NULL      1123-12      487753.29
7042      1123      NULL      1123-13      456048.65
7043      1123      NULL      1123-14      442754.03
7044      1123      NULL      1123-15      442350.84

That returns 13 Rows where in my case in my detail would be only:
LoanID
7030

as it's the only with RelID grouped count > 1 and out of the 3 records with RelID 1123-1 it has the highest amount.  Also I the RelSeq Desc may be an issue later as I need to go after where it is = 1 in the case where there is a.  Such as if I had:
7045      1123      NULL      1123-99      456048.65
7046      1123      1      1123-99      442754.03
7047      1123      NULL      1123-99      442350.84

I would want the 7046 record.

Perfect World
I will increase the points of this to 500 if I could get help with this which I think would make my life a lot easier.    If I could return a record set like this would be perfect in my case not sure how hard this would be to do but a huge help for me:

If I had this data here:
LoanId      PoolId      RelSeq      RelID      Amount
7030      1123      NULL      1123-1      4468547.79
7031      1123      NULL      1123-2      2724929.25
7032      1123      NULL      1123-3      2675334.52
7033      1123      NULL      1123-1      2665100.77
7034      1123      NULL      1123-5      2277303.22
7035      1123      NULL      1123-6      2185009.11
7036      1123      NULL      1123-7      1020178.69
7037      1123      NULL      1123-1      859755.98
7038      1123      NULL      1123-9      849044.17
7039      1123      NULL      1123-10      676773.52
7040      1123      NULL      1123-11      512084.90
7041      1123      NULL      1123-12      487753.29
7042      1123      NULL      1123-13      456048.65
7043      1123      NULL      1123-14      442754.03
7044      1123      NULL      1123-15      442350.84
7045      1123      NULL      1123-99      456048.65
7046      1123      1      1123-99      442754.03
7047      1123      NULL      1123-99      442350.84

If I could get this return it would be awesome and save me a lot of queries.

LoanId      PoolId      RelSeq      RelID      Amount              IsPrimary    SecondaryLoanId    
7030      1123      NULL      1123-1      4468547.79        1                   NULL
7031      1123      NULL      1123-2      2724929.25        NULL           NULL
7032      1123      NULL      1123-3      2675334.52        NULL           NULL
7033      1123      NULL      1123-1      2665100.77        NULL           7030
7034      1123      NULL      1123-5      2277303.22        NULL           NULL
7035      1123      NULL      1123-6      2185009.11        NULL           NULL
7036      1123      NULL      1123-7      1020178.69        NULL           NULL
7037      1123      NULL      1123-1      859755.98          NULL           7030
7038      1123      NULL      1123-9      849044.17          NULL           NULL
7039      1123      NULL      1123-10      676773.52          NULL           NULL
7040      1123      NULL      1123-11      512084.90          NULL           NULL
7041      1123      NULL      1123-12      487753.29          NULL           NULL
7042      1123      NULL      1123-13      456048.65          NULL           NULL
7043      1123      NULL      1123-14      442754.03          NULL           NULL
7044      1123      NULL      1123-15      442350.84          NULL           NULL
7045      1123      NULL      1123-99      456048.65          NULL           7046
7046      1123      1      1123-99      442754.03          1                   NULL
7047      1123      NULL      1123-99      442350.84          NULL           7046

This would make my life so much easier to go after the way I need to put some report data together.    My idea is to be able to query to get the Primary Loans only and then the secondary loans for that primary then all the NULL NULL loans I need next.   Any help would be much appreciated.

thanks