Database

Xarzu wrote:

How do you use the AVG api function in sql

Bastard Programmer from Hell
if you can't read my code, try converting it here[^]

Select City, AVG(Salary) AS Salary
FROM @t
Group By City
Order By City DESC

Select City,Salary From
(
    Select
        Rn = Row_Number() Over(PARTITION BY City Order By (Select 1))
        ,City
        ,AVG(Salary) OVER(PARTITION BY City) AS Salary
    From @t) X
Where X.Rn = 1
Order By City DESC

leketekoa wrote:

oracle database2 is

leketekoa wrote:

nd report back

snowman53 wrote:

I did find Sesame, which seems to have taken over Q&A, but they want $350 for the program

Bastard Programmer from Hell
if you can't read my code, try converting it here[^]

snowman53 wrote:

are upset I can't re-install Q&A without the original copies!

Bastard Programmer from Hell
if you can't read my code, try converting it here[^]

Create Table T1 (Col1 int, Col2 varchar(50))
Insert into T1 Select 1001,'WA'
Insert into T1 Select 1001,'CA'
Insert into T1 Select 1002,'WA'
Insert into T1 Select 1001,'WA'
Select Col1 From
(
    Select *,ROW_NUMBER()Over(partition by Col1 Order by Col1) RN
    From (Select Col1,Col2 From T1
            Group by Col1,Col2)T1
)A Where RN>1

SELECT [Acc No] FROM table
GROUP BY State
HAVING COUNT(State) > 1