Skip to main content

Return to Answer

added 16 characters in body
Source Link
gipinani
gipinani
  • 14.4k
  • 12
  • 63
  • 90

select count(*) from ( SELECT distinct column1,column2,column3,column4 FROM abcd ) T

select count(*) from ( SELECT distinct column1,column2,column3,column4 FROM abcd ) T

This will give count of distinct group of columns.

select count(*) from ( SELECT distinct column1,column2,column3,column4 FROM abcd ) T

This will give count of distinct group of columns.

select count(*) from ( SELECT distinct column1,column2,column3,column4 FROM abcd ) T

This will give count of distinct group of columns.

Source Link
Vaibhav
Vaibhav

select count(*) from ( SELECT distinct column1,column2,column3,column4 FROM abcd ) T

This will give count of distinct group of columns.