Table of contents:
- How to display length of fieald in table?
- How to select unique name?
- Dipslay all departments - example
- Select employee with WHERE clause, checking employee with the name equal to: ‘Jessica’
- Check employee with the last name starting from: ‘J’
- Check employee with: ‘e’ character in name
- Example of filtering on data value
- Create a column aliases
Ok, let’s practice basic database queries, SQL Oracle Database. Below is the database schema
- Database Schema
-
How to display length of fieald in table?
Output:
-
How to select unique name?
Output:
Output:
-
Select employee with WHERE clause, checking employee with the name equal to: ‘Jessica’
-
Check employee with the last name starting from: ‘J’
Ouptut:
-
Check employee with: ‘e’ character in name
-
Example of filtering on data value
Output:
Output:
Reference:
- Oracle SQL Developer
- Microsoft SQL documentation
My site is free of ads and trackers. Was this post helpful to you? Why not