© Ben Brumm 2019
Ben BrummBeginning Oracle SQL for Oracle Database 18chttps://doi.org/10.1007/978-1-4842-4430-2_9

9. Removing Duplicate Results

Ben Brumm1 
(1)
Melbourne, VIC, Australia
 

When you store data in a table, as you have learned so far, you can just enter the values and save it. The data is then saved into the table. As long as the values you enter match the type of column, then it should work. This means you can’t enter a text value into a number column, for example.

Your sample data looks like this so far:
ID   LAST_NAME   SALARY
1    JONES       20000
2    SMITH       35000
3    KING        40000
4    SIMPSON     52000
5    ANDERSON    31000
6    COOPER      NULL
7    NULL        NULL
Looking at this table, you may assume a few things:
  • The ID number ...

Get Beginning Oracle SQL for Oracle Database 18c: From Novice to Professional now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.