Q. Write a query to display EName and Sal of employees whose salary is greater than or equal to 2200 from table Empl.


Table ----





Answer: -


Select EName, Sal from Empl

Where sal >= 2200 ;

23 Comments

You can help us by Clicking on ads. ^_^
Please do not send spam comment : )

  1. SELECT ename, sal FROM Empl WHERE sal>=2200;

    ReplyDelete
    Replies
    1. hello there r multiple ways to write query=========
      type 1 SELECT ename, sal FROM Empl WHERE sal>=2200;
      type 2 SELECT ename, sal FROM Empl
      WHERE sal>=2200;
      type 3 SELECT ename, sal
      FROM Empl
      WHERE sal>=2200;

      can be written in 3 ways

      Delete
  2. ** where sal>=2200;. Apne salary likha hua h

    ReplyDelete
  3. cooooooooooooool

    ReplyDelete
  4. bro anime mass bro

    ReplyDelete
  5. bro see tokyo revengers bro

    ReplyDelete
  6. nice one bro eat your dosa

    ReplyDelete
  7. or snakes or dogs..

    ReplyDelete
  8. Why we use short forms like empl instead of employees

    ReplyDelete
    Replies
    1. because we have named the table as empl so we have to use that table name only. If you have named your table as employee then use employee instead of empl

      Delete
  9. Why do plants feed on insect

    ReplyDelete

Post a Comment

You can help us by Clicking on ads. ^_^
Please do not send spam comment : )

Previous Post Next Post