Database

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

Column [Acc No] is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

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

SELECT DISTINCT(col1)
FROM t1
GROUP BY col1,col2
HAVING COUNT(col1) < 2

SELECT      DISTINCT A.Acc_No,count(*)
FROM        [Test].[dbo].[Table_2] A
JOIN  [Test].[dbo].[Table_2] B
on A.Emp_state = B.Emp_state
group by A.Acc_No having COUNT(*)>1

INSERT INTO Table( field1,field2)
VALUES (@value1, @value2);