Create count-diff.sql (Baeldung#44)

letscodewithsriram · web-flow · commit f40e78ebffe9 · 2024-06-30T13:51:32.000+02:00
diff --git a/sql-queries-2/sql-count-diff/count-diff.sql b/sql-queries-2/sql-count-diff/count-diff.sql
@@ -0,0 +1,17 @@
+select * 
+  FROM Department;
+
+select COUNT(*) 
+  FROM Department;
+
+select COUNT(id) 
+  FROM Department;
+
+select COUNT(name) 
+  FROM Department;
+
+select COUNT(DISTINCT id) 
+  FROM Department;
+ 
+select COUNT(DISTINCT name) 
+  FROM Department;
