Scribd Logo
Upload

Welcome to Scribd!

  • 71 views

    Table: Worker Default Date Formate" Dd-Mon-Rr

    Uploaded by

    pratik dholakiya
    The document contains 31 questions asking to write SQL queries to retrieve or manipulate data from a Worker table. The questions cover a range of basic to more advanced SQL topics like selecting, filtering, aggregating, joining, ordering and grouping data.

    Copyright:

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

    Table: Worker Default Date Formate" Dd-Mon-Rr

    Uploaded by

    pratik dholakiya
    71 views4 pages
    The document contains 31 questions asking to write SQL queries to retrieve or manipulate data from a Worker table. The questions cover a range of basic to more advanced SQL topics like selecting, filtering, aggregating, joining, ordering and grouping data.

    Original Description:

    sql queries

    Original Title

    sql querIES

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains 31 questions asking to write SQL queries to retrieve or manipulate data from a Worker table. The questions cover a range of basic to more advanced SQL topics like selecting, filtering, aggregating, joining, ordering and grouping data.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    71 views4 pages

    Table: Worker Default Date Formate" Dd-Mon-Rr

    Uploaded by

    pratik dholakiya
    The document contains 31 questions asking to write SQL queries to retrieve or manipulate data from a Worker table. The questions cover a range of basic to more advanced SQL topics like selecting, filtering, aggregating, joining, ordering and grouping data.

    Copyright:

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

    TABLE: WORKER DEFAULT DATE FORMATE” DD-MON-RR

    TABLE: BONUS
    TABLE: TITLE

    Q-1. Write An SQL Query To Fetch “FIRST_NAME” From Worker Table Using The Alias Name As
    <WORKER_NAME>.

    Q-2. Write An SQL Query To Fetch “FIRST_NAME” From Worker Table In Upper Case.

    Q-3. Write An SQL Query To Fetch Unique Values Of DEPARTMENT From Worker Table.

    Q-4. Write An SQL Query To Print The First Three Characters Of FIRST_NAME From Worker Table.

    Q-5. Write An SQL Query To Find The Position Of The Alphabet (‘A’) In The First Name Column ‘Amitabh’
    From Worker Table.

    Q-6. Write An SQL Query To Print The FIRST_NAME From Worker Table After Removing White Spaces
    From The Right Side.

    Q-7. Write An SQL Query To Print The DEPARTMENT From Worker Table After Removing White Spaces
    From The Left Side.

    Q-8. Write An SQL Query That Fetches The Unique Values Of DEPARTMENT From Worker Table And
    Prints Its Length.

    Q-9. Write An SQL Query To Print The FIRST_NAME From Worker Table After Replacing ‘a’ With ‘A’.

    Q-10. Write An SQL Query To Print The FIRST_NAME And LAST_NAME From Worker Table Into A Single
    Column COMPLETE_NAME. A Space Char Should Separate Them.
    Q-11. Write An SQL Query To Print All Worker Details From The Worker Table Order By FIRST_NAME
    Ascending.

    Q-12. Write An SQL Query To Print All Worker Details From The Worker Table Order By FIRST_NAME
    Ascending And DEPARTMENT Descending.

    Q-13. Write An SQL Query To Print Details For Workers With The First Name As “Vipul” And “Satish”
    From Worker Table.

    Q-14. Write An SQL Query To Print Details Of Workers Excluding First Names, “Vipul” And “Satish” From
    Worker Table.

    Q-15. Write An SQL Query To Print Details Of Workers With DEPARTMENT Name As “Admin”.

    Q-16. Write An SQL Query To Print Details Of The Workers Whose FIRST_NAME Contains ‘A’.

    Q-17. Write An SQL Query To Print Details Of The Workers Whose FIRST_NAME Ends With ‘A’.

    Q-18. Write An SQL Query To Print Details Of The Workers Whose FIRST_NAME Ends With ‘H’ And
    Contains Six Alphabets.

    Q-19. Write An SQL Query To Print Details Of The Workers Whose SALARY Lies Between 100000 And
    500000.

    Q-20. Write An SQL Query To Print Details Of The Workers Who Have Joined In Feb’2014.

    Q-21. Write An SQL Query To Fetch The Count Of Employees Working In The Department ‘Admin’.

    Q-22. Write An SQL Query To Fetch Worker Names With Salaries >= 50000 And <= 100000.

    Q-23. Write An SQL Query To Fetch The No. Of Workers For Each Department In The Descending Order.

    Ans.
    Q-24. Write An SQL Query To Print Details Of The Workers Who Are Also Managers.

    Q-25. Write An SQL Query To Fetch Duplicate Records Having Matching Data In Some Fields Of A Table.

    Q-26. Write An SQL Query To Show Only Odd Rows From A Table.

    Q-27. Write An SQL Query To Show Only Even Rows From A Table.

    Q-28. Write An SQL Query To Clone A New Table From Another Table.

    Q-29. Write An SQL Query To Fetch Intersecting Records Of Two Tables.

    Q-30. Write An SQL Query To Show Records From One Table That Another Table Does Not Have.

    Q-31. Write An SQL Query To Show The Current Date And Time.

    You might also like