View Feed
group-icon
Coffee Room
Discuss anything here - everything that you wish to discuss with fellow engineers.
12920 Members
Join this group to post and comment.

solve sql query.

i have attached question in a image. please solve my query someone.
Kaustubh Katdare
Kaustubh Katdare • Dec 23, 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.
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 • 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;
Koushal Patel
Koushal Patel • Dec 26, 2016
Parimal202020
(2) SELECT *FROM EMPLOYEE WHERE SALARY BETWEEN'20000 AND 30000';
Department Name Filter is not present.
mohini hire
mohini hire • Dec 27, 2016
select * from employee
where ((empsalary>20000) and (empsalary<30000));

Share this content on your social channels -