Question 12 Marks
Write the SQL statements for the following:
(a) Extract the "net "from the word "Internet ".
(b) Print the month of your date of birth.
5 questions · timed · auto-graded
(a) Extract the "net "from the word "Internet ".
(b) Print the month of your date of birth.
Join is used to combine records from two or more tables in a database. Equi Join is used to compare the two or more tables with matching values and return the result.
For example, length and case conversion functions are single row functions.
Multiple row functions work upon group of rows and return one result for the complete set of rows. They are also known as Group Functions. Single row functions.
What do you mean by Referential Integrity?
Where clause is used for selecting the rows based on the condition applied on rows. While HAVING clauses used to select the rows from the data given by group by clause in SQL.