1.1 Suppose you want to retrieve data from the studentlist table, and the following error occurs SELECT * FROM studentlst; ORA-00942: table or view does not exist 00942. 00000 - "table or view does not exist" *Cause: *Action: Error at Line: 2 Column: 6 Explain the error message and what is the possible cause of the error 1.2 Write a query to display the information of students whose last name contains letter ‘y’ and were admitted from year 2020 and above. 1.3 The DISTINCT keyword removes duplicate rows from your results, not duplicate values from each column. Write a query to implement DISTINCT keyword on Studentlist table to find unique last names. 1.4 Write a query to find unique first names and last names of the students contained in the Studentlist table 1.5 Use the IN keyword to find the students whose first names are Evelyn, Samson, and Paul from the Studentlist
1.1 Suppose you want to retrieve data from the studentlist table, and the following error occurs
SELECT *
FROM studentlst;
ORA-00942: table or view does not exist
00942. 00000 - "table or view does not exist"
*Cause:
*Action:
Error at Line: 2 Column: 6
Explain the error message and what is the possible cause of the error
1.2 Write a query to display the information of students whose last name contains letter ‘y’ and
were admitted from year 2020 and above.
1.3 The DISTINCT keyword removes duplicate rows from your results, not duplicate values
from each column. Write a query to implement DISTINCT keyword on Studentlist table to
find unique last names.
1.4 Write a query to find unique first names and last names of the students contained in the
Studentlist table
1.5 Use the IN keyword to find the students whose first names are Evelyn, Samson, and Paul
from the Studentlist
Step by step
Solved in 6 steps with 4 images