I have a database table in following format
GID ID VALUE
1 1 TRUE
1 2 TRUE
1 3 TRUE
2 4 FALSE
2 5 TRUE
What is want is it should groupby GID and shold display like this
i.e. for each GID TRUE is returned if each of its ID is TRUE, otherwise returns FALSE.
How to do this using SQL or T-SQL whatever........