SQL - Hands-On Exercises (Session 11)

1)create or replace view view_alumni_details as select u.name as user_name,d.name as degree_name ,p.batch,u.phonenumber,u.emailid from ...

SQL - Hands-On Exercises (Session 10)

1)select name from user where profile_id in (select profile_id from higher_degree where university_name='Texas University')order...

SQL - Hands-On Exercises (Session 9)

1)select user.name from user,role where role.id=user.role_id and role.name='admin' order by user.name asc; 2)select user.name ...

SQL - Hands-On Exercises (Session 8)

1.select role.name,count(*) as role_count from user inner join role on user.role_id=role.id where user.role_id is not null group by user...

SQL - Hands-On Exercises (Session 7)

1) select role.*,user.* from role Inner join user on role.id=user.role_id order by role.name asc, user.name asc; 2)select rol...

SQL - Hands-On Exercises (Session 6)

1.       select name,length(name) as length from user order by name; 2.       Select name From user Where length(name) IN (Select...

SQL - Hands-On Exercises (Session 5)

1)select abs(2) 2)select abs(-32) as absolute; 3)select ceiling(1.23) as int_value; 4)select ceil(-1.23) as int_value; 5)select conv(...

SQL - Hands-On Exercises (Session 4)

1) select count(*) as 'role_count' from role; 2) select count(*) as 'skill_count' from skill; 3) select count(*) ...