Write SQL code which declares two variables for name and address. Store your name and address in respective variables. Display name and address in a single line using print statement.
Write SQL queries for the following statements.
1) Write SQL code which declares two variables for name and address. Store your name and address in respective variables. Display name and address in a single line using print statement.
2) Display table of 10 in given format using
10 x 1 = 10
10 x 2 = 20
.
.
.
10 x 10 = 100.
3) Write a code which declares a variable and stores age of youngest employee from “Employee” table. And display name of youngest employee 5 times his.
4) Assume that in “Employee” table, Emp_id are assigned from 1 to onward. ie first employee’s eid is 1, second employee’s eid is 2 and so on. Write a code that displays name of eldest employee without using aggregate function of “max”. You can use count function
Step by step
Solved in 2 steps
