SELECT Query

Q:4
Display the details of deposit with maximum deposit.


SQL> SELECT * FROM DEPOSIT WHERE AMOUNT=(SELECT MAX(AMOUNT) FROM DEPOSIT);

     ACCNO NAME                      BRANCH                   AMOUNT
---------- ------------------------- -------------------- ----------
      1006 DEVA KUMAR                CALICUT                   60000