Scribd Logo
Upload

Welcome to Scribd!

  • 2 views

    CSBS3152-AS2

    Uploaded by

    Rik S

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd

    CSBS3152-AS2

    Uploaded by

    Rik S
    2 views1 page

    Copyright

    © © All Rights Reserved

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    2 views1 page

    CSBS3152-AS2

    Uploaded by

    Rik S

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    You are on page 1of 1

    Database Management System Lab

    CSBS3152
    Assignment No. - II

    1. Write a query to show the emp table.


    2. Write A query to show the annual salary of all employees with a new
    field name.
    3. Display the employee name who hired after '19-APR-1987'.
    4. Create a query to display a unique job.
    5. Display details of all clerks.
    6. Display the employee number, employee name, job and department of
    JAMES.
    7. Display the name of all employees whose name has an 'A' as the
    second character.
    8. Display the employee who has no manager.
    9. Display the details of all clerk who earn more than 1100.
    10. Display the employee name and department number of all employees in department 10
    and department 30 in alphabetical order by name.
    11. Display the name and salary of employees who earn more than 1500 and are in
    department 10 or 30.
    12. Display the name, salary and commission for all employees who earn
    commissions. Sort the data in descending order of salary.
    13. Display the name of all employees who have double L in their name.
    14. Write a query to display the current date.
    15. Write a query that will display all employee name in lower case and
    the length of their name.

    Page - 1

    You might also like