Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

c ) Write SQL Commands to perform following operations on View. i . Create a view to fetch enrollment number, name, and percentage from student

c) Write SQL Commands to perform following operations on View. i. Create a view to fetch enrollment number, name, and percentage from student table and name it as S View. ii. Display record from S_View where percentage is greater than 60. Delete view named as S_view,

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Seven Databases In Seven Weeks A Guide To Modern Databases And The NoSQL Movement

Authors: Luc Perkins, Eric Redmond, Jim Wilson

2nd Edition

1680502530, 978-1680502534

More Books

Students also viewed these Databases questions

Question

2. You seem to feel frustrated when Lee doesnt do his homework.

Answered: 1 week ago

Question

Describe several uses for a position description.

Answered: 1 week ago