0

Problem is based on SQL mentioned in Description down help me out

PRACTICAL 1: CREATING A SINGLE TABLE WITHOUT CONSTRAINTS AND FIRING SELECT QUERIES. 1. Friends is an entity set with attributes last name (Lname), first name ( Fname), address, city and age. Convert an entity set to table with suitable data types for attributes. Add 5 meaningful records. Fire the following queries: 1. Display all the tuples of the table. 2. Retrieve first and last name of all friends. 3. Fetch all the friends with age more than 25. 4. Retrieve all friends with Mumbai city and age less than 20 or last name Shah. 5. Retrieve all first and last names with age lies between 20 and 30.

16th Oct 2020, 6:08 PM
Hritik Ulhas Mumbarkar
Hritik Ulhas Mumbarkar - avatar
2 Antworten
+ 2
For creating table https://www.sololearn.com/learn/SQL/1870/ For inserting records https://www.sololearn.com/learn/SQL/1868/ You can find all of it in the SQL course.
16th Oct 2020, 6:40 PM
Avinesh
Avinesh - avatar
0
Thanks Avinesh
17th Oct 2020, 6:14 AM
Hritik Ulhas Mumbarkar
Hritik Ulhas Mumbarkar - avatar