Exercise #15 (computer firm) | Interactive tutorial on SQL

	Common mistakes in solving SELECT statement exercises Computer Firm Database Exercise #15
	Get hard drive capacities that are identical for two or more PCs. This incorrect solution is the result of a superficial knowledge of the database schema: Solution 1.11.1 Console Execute SELECT DISTINCT t.hd FROM PC t WHERE EXISTS (SELECT * FROM PC WHERE pc.hd = t.hd AND pc.model <> t.model ); SELECT DISTINCT t.hd FROM PC t WHERE EXISTS (SELECT * FROM PC WHERE pc.hd = t.hd AND pc.model <> t.model ); Scheme This query gets such PCs for which another PC model having the same hard drive capacity exists. The mistake lies in the intuitive assumption of the model uniqueness in the PC table. However, as mentioned earlier, models are unique in the Product table only; in other tables, duplicates can occur. This fact renders the query under review wrong, since it excludes identical models with the same hard drive capacity from consideration. T&S Solve this task at SQL-EX.RU mistakes PC EXISTS exercise 15

SQL Problems and solutions