CrazyEngineers
CrazyEngineers

  • solve sql query.

    PRAJAPATI PARIMAL

    Member

    Updated: Oct 26, 2024
    Views: 1.4K
    i have attached question in a image. please solve my query someone.
    0
    Replies
Howdy guest!
Dear guest, you must be logged-in to participate on CrazyEngineers. We would love to have you as a member of our community. Consider creating an account or login.
Replies

  • Kaustubh Katdare

    Administrator • Dec 23, 2016

    #-Link-Snipped-# - Have you made any attempt at writing the queries on your own? Give it a try so that others can help you correct your queries.
    Are you sure? This action cannot be undone.
    Cancel

  • PRAJAPATI PARIMAL

    Member • Dec 23, 2016

    MY SQL QUERY'S ANSWER IS :
    (1) SELECT *FROM DEPOSIT WHERE BRANCH NAME LIKE 'D%';
    (2) SELECT *FROM EMPLOYEE WHERE SALARY BETWEEN'20000 AND 30000';
    (3) DELETE FROM BORROW WHERE AMOUNT<25000;

    IS MY ALL ANSWER ARE CORRECT OR NOT ?
    Are you sure? This action cannot be undone.
    Cancel

  • Koushal Patel

    Member • Dec 26, 2016

    SELECT CUST_NAME FROM DEPOSIT WHERE BRANCH_NAME LIKE 'D%';
    OR
    SELECT CUST_NAME FROM DEPOSIT WHERE SUBSTR(BRANCH_NAME,1,1) = 'D';

    SELECT EMP.EMP_NAME
    FROM EMPLOYEE EMP
    INNER JOIN DEPARTMENT DEPT ON EMP.DEPT_NO = DEPT.DEPT_NO
    WHERE EMP.EMP_SALARY BETWEEB 20000 AND 30000 AND DEPT.DEPT_NAME = 'Finance';

    DELETE FROM BORROW WHERE AMOUNT < 25000;
    Are you sure? This action cannot be undone.
    Cancel

  • Koushal Patel

    Member • Dec 26, 2016

    Parimal202020
    (2) SELECT *FROM EMPLOYEE WHERE SALARY BETWEEN'20000 AND 30000';
    Department Name Filter is not present.
    Are you sure? This action cannot be undone.
    Cancel

  • mohini hire

    Member • Dec 27, 2016

    select * from employee
    where ((empsalary>20000) and (empsalary<30000));
    Are you sure? This action cannot be undone.
    Cancel
Home Channels Search Login Register