Select Query for the same values
Using SQL Server 2000

I Want to Check the colum value whether it is same or not

    Table1
    
    ID Value
    
    001 1000
    002 1000
    003 5000

From the above table, nothing display in the output, because values are differenct for each id.

If the values are same for all the id, then display otherwise nothing display.

How to make a select query.

Need Query Help


Select Query for the same values
===

Using SQL Server 2000

I Want to Check the colum value whether it is same or not

    Table1
    
    ID Value
    
    001 1000
    002 1000
    003 5000

From the above table, nothing display in the output, because values are differenct for each id.

If the values are same for all the id, then display otherwise nothing display.

How to make a select query.

Need Query Help

