Database

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);

mark merrens wrote:

Really? How bizarre.

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

ASPnoob wrote:

VALUES ('@value1', '@value2'); ... param.ParameterName="@myvalue";

Yazdan Attarian wrote:

when i want to change a field or add a field an error raised