simple sql query

Question

I am getting an error in this query like incorrect syntax near distinct statement

DECLARE  @CNT INT
SELECT @CNT= DISTINCT ISNULL(Employee.id,0)
FROM Employee 
WHERE EMPLOYEE.NAME='KIRAN'

is there anything wrong in syntax

SELECT  DISTINCT ISNULL(Employee.id,0)
FROM Employee 
WHERE EMPLOYEE.NAME='KIRAN'

this statements works fine

thanks prince

redrobot · Accepted Answer · 2011-04-27 08:43:11Z

1

Something like this maybe ..

DECLARE  @CNT INT
SET @CNT = (SELECT DISTINCT ISNULL(Employee.id,0)
FROM Employee 
WHERE EMPLOYEE.NAME='KIRAN')

answered Apr 27, 2011 at 8:43

redrobot

1,0092 gold badges15 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

than you have a problem .. but that wasn't the question

the Query returns same value even for multiple row values

AEMLoviji · Accepted Answer · 2011-04-27 08:44:03Z

0

1.use must write distinct before @CNT variable
2.select only first row because @cnt not table variable it is variable which type is int

DECLARE  @CNT INT
SELECT top 1 @CNT= ISNULL(Employee.id,0)
FROM Employee 
WHERE EMPLOYEE.NAME='KIRAN'

you can test it simply

declare @CNT INT

SELECT top 1 @CNT= ISNULL(Employee.id,0)
FROM Employee 
WHERE EMPLOYEE.NAME='KIRAN'

select @CNT

answered Apr 27, 2011 at 8:44

AEMLoviji

3,2779 gold badges41 silver badges61 bronze badges