Scribd Logo
Upload

Welcome to Scribd!

  • 290 views

    Simple and Complex Query

    Uploaded by

    Saibullah Khan
    A simple query searches using one parameter or search criteria, while a complex query searches using more than one parameter. To create a query, one selects the table and fields in the query wizard and provides a title. The key differences are that complex queries can join tables, use grouping and ordering, and may not allow data manipulation operations like simple views.

    Copyright:

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

    Simple and Complex Query

    Uploaded by

    Saibullah Khan
    290 views6 pages
    A simple query searches using one parameter or search criteria, while a complex query searches using more than one parameter. To create a query, one selects the table and fields in the query wizard and provides a title. The key differences are that complex queries can join tables, use grouping and ordering, and may not allow data manipulation operations like simple views.

    Original Title

    SIMPLE AND COMPLEX QUERY

    Copyright

    © © All Rights Reserved

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    A simple query searches using one parameter or search criteria, while a complex query searches using more than one parameter. To create a query, one selects the table and fields in the query wizard and provides a title. The key differences are that complex queries can join tables, use grouping and ordering, and may not allow data manipulation operations like simple views.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    290 views6 pages

    Simple and Complex Query

    Uploaded by

    Saibullah Khan
    A simple query searches using one parameter or search criteria, while a complex query searches using more than one parameter. To create a query, one selects the table and fields in the query wizard and provides a title. The key differences are that complex queries can join tables, use grouping and ordering, and may not allow data manipulation operations like simple views.

    Copyright:

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

    SIMPLE AND COMPLEX QUERY

    MADE BY: MAHERYAR


    WHAT IS SIMPLE QUERY?

    A simple query is a query that searches using just one parameter. A


    simple query might use all of the fields in a table and search using just
    one parameter. or it might use just the necessary fields about which the
    information is required, but it will still use just one parameter (search
    criteria) A query is a request for data results, and for action on data. You
    can use a query to answer a simple question, to perform calculations, to
    combine data from different tables, or even to add, change, or delete
    table data.
    WHAT IS COMPLEX QUERY?

    A complex query is a parameter query that searches using


    more than one parameter value i.e. on two or more
    criteria. Complex SQL
    .
    is the use of SQL queries which
    go beyond the standard SQL of using the SELECT and
    WHERE commands. Complex SQL often involves using
    complex joins and sub-queries, where queries are nested
    in WHERE clauses. Complex queries frequently involve
    heavy use of AND and OR clauses.
    STEPS TO CREATE A QUERY

    Go to the CREATE Tab.


    Go to the OTHER group on the far right.
    Click on Query Wizard.
    This is just like creating a report. Pick the table
    you want to query. Pick the fields you want to look
    at. Click NEXT. Type in the title of the Query.
    Click FINISH.
    DIFFERENCE BETWEEN COMPLEX
    AND SIMPLE QUERY.
    Complex views can be constructed on more than one base table.
    In particular, complex views can contain: join conditions, a
    group by clause, a order by clause.
    ...
    Difference between Simple and Complex View in SQL.
    Simple View Complex View
    DML operations could be performed through a simple view.
    DML operations could not always be performed through a
    complex view.

    You might also like