Question:1 Create the following table in sqlplus through query? Student_info Reg_no Nicno Name Address Fee Marks Grade Question:2 Insert the data in the above created table? Question:3 Show all data from table Student_info?
Question:1
Create the following table in sqlplus through query?
Student_info
|
Reg_no |
Nicno |
Name |
Address |
Fee |
Marks |
Grade |
Question:2
Insert the data in the above created table?
Question:3
Show all data from table Student_info?
Question:4
Show Student name, reg no, marks and grade from the table Student_info?
Question:5
In July 2014 salary of employees increase 800 per head you perform this action in emp table. And show its total annually salary.
Question:6
In every month transport charges are detected from employ salary your task is to show this problem in sql emp table.
Question:7
Find out employ annual salary and minus the old benefits amount from emp salary where old benefit amount is 132.
Question:8
Find out the 15 days salary of employee.
Question:9
Find out total salary of employ if minus the salary of 4 weeks ends.
Step by step
Solved in 2 steps
