Write the SQL commands to answer the queries based on “Emp_Details” table
ID NAME AGE ADDRESS SALARY PHONE
1 Karan Yadav 25 Delhi 62000 1234567890
2 Soham More 23 Mumbai 71000 5462378190
3 Sahil Sutar 26 Bhopal 65000 5564791356
4 Sonali Kulkarni 22 Delhi 89000 9998654573
5 Sushant Patil 27 Chennai 94000 7689141235
a) To display list of all employees below 25 years old .
b) To display records in descending order of salary.
c) To insert the following records
( 6 ,”Sudhanshu Kale” , 22 ,”Chennai” , 64000 , 9988774423)
d) To display records whose address is Bhopal.
e) Create a form and report to display data from table “Emp_Details” using different
controls , styles and layout .
Share
0 Replies