Q. Write a query to display employee name and salary of those employee who don't have there salary in the range of 2500 to 4000.
Table --
Answer :-
Select ename , sal from Empl
Where sal not between 2500 and 4000 ;
Table --
Answer :-
Select ename , sal from Empl
Where sal not between 2500 and 4000 ;
can it be this too? select ename, sal from Empl where sal<2500 and sal>4000
ReplyDeleteYes, but you have written wrong query. It should be sal > 2500 and sal < 4000
Deletesal>2500 and sal<4000 is between 2500 and 4000 sir..
ReplyDeleteit's like 2500<sal<4000..we want not between 2500 & 4000?!
I have written "not" in query.
DeleteThank u ❤️ 💓 💗 💖 💛 ☺️ ❤️ 💓 💗 💖 💛 ☺️ ❤️
ReplyDeleteWelcome 😊😊😊👍
DeleteSelect ename , sal from Empl
ReplyDeleteWhere sal not between 2500 and 4000 ;
Why have you copied the answer.
DeleteTQSM Sir or Mam
ReplyDeleteAlways Welcome : )
Deletewelcome. i am from path wala and very good at cs
ReplyDelete😁😁😂😂😂
DeleteNaam batao
ReplyDeleteWhy ????
Deletei guess you are from south india cause all the geeks are there only XD
ReplyDeleteThnk u so muchh ❤️
ReplyDeletePost a Comment
You can help us by Clicking on ads. ^_^
Please do not send spam comment : )