SESSION NAME: Views.
QUESTION NAME: Views - 10.
TABLE DESCRIPTION:
For example your registration number is
RA1511003010255 the create a view as RA1511003010255_10.
The view should be created for countries table for the
following fields:
1. country_id
2. country_name
After creating view for the above mentioned fields display
the view.
Hint:
1. Create a view with specified name.
2. After creating the view delete the lines in the code editor
3. Display the view (select * from viewname)
CODE:
SELECT country_id, country_name FROM RA1931005040030_10;
3 Comments
Thank you king
ReplyDeleteSELECT country_id, country_name
ReplyDeleteFROM countries;
For Views - 1:
ReplyDeleteTABLE DESCRIPTION
Create a VIEW as your RegistrationNumber_01.
For example your registration number is RA1511003010255 the create a view as RA1511003010255_01.
The view should be created for CITY table for the following fields:
1. ID
2. NAME
3. COUNTRYCODE
After creating view for the above mentioned fields display the view.
Hint:
1. Create a view with specified name.
2. After creating the view delete the lines in the code editor
3. Display the view (select * from viewname
Code:
SELECT ID, NAME, COUNTRYCODE
FROM CITY;