PRAJAPATI PARIMAL
PRAJAPATI PARIMAL
Branch Unspecified
23 Dec 2016

solve sql query.

i have attached question in a image. please solve my query someone.
23 Dec 2016
@Parimal202020 - 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.
PRAJAPATI PARIMAL

PRAJAPATI PARIMAL

Branch Unspecified
23 Dec 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 ?
Koushal Patel

Koushal Patel

Branch Unspecified
26 Dec 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;
Koushal Patel

Koushal Patel

Branch Unspecified
26 Dec 2016
Parimal202020
(2) SELECT *FROM EMPLOYEE WHERE SALARY BETWEEN'20000 AND 30000';
Department Name Filter is not present.
mohini hire

mohini hire

Branch Unspecified
27 Dec 2016
select * from employee
where ((empsalary>20000) and (empsalary<30000));

Share this content on your social channels -

Only logged in users can reply.