Discuss the concept of surrogate key in database design, from what it is to when to use it.
Archive for the 'SQL' Category
Discusses the concept of composite key in SQL, and shows examples of creating a composite key in MySQL, Oracle, and SQL Server.
Shows the syntax to rename a table in MySQL, Oracle, and SQL Server.
Shows how to find the 2nd largest number in SQL across different database systems.
Find out how to use SQL to find duplicates in a table. In addition, learn how to retrieve all records that contain duplicates.
Describes how to copy a table in a relational database using SQL. You can either copy just the table structure, or the table structure and the data.