/SQL/Distinct data types in a table sql query

Distinct data types in a table sql query

select table_name, count(*)
from 
	(select distinct data_type as data_type, table_name 
	 FROM information_schema.columns
	WHERE table_name like '<table-name>') t
group by table_name

Similar codes

1 vote179 views4 answers
Between vs in sql
SQL
4 votes199 views6 answers
List all tables in postgres
SQL
0 vote235 views1 answer
Mysql faster delete
SQL
0 vote194 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
3 votes214 views1 answer
Mysql replace string in table
SQL
5 votes250 views1 answer
Oracle ora-00054 resource busy
SQL
0 vote192 views1 answer
Mysql two joins
SQL
2 votes186 views1 answer
Oracle index size calculation
SQL
1 vote232 views1 answer
Round one decimal place mysql
SQL
0 vote192 views1 answer
Update one column from another column in same table
SQL