HomeSimple Queries in SQL Write a query to display the name, job title and salary of employee who do not have manager. 26 Comments Facebook Twitter Q Write a query to display the name, job title and salary of employee who do not have manager. Table :- Answer :-Select ename , job , sal from EmplWhere job <> "manager" ;
Helo
ReplyDeleteYes, What happens.
Deletethanks
ReplyDeleteWelcome 😊😊
Deletewhere is not equal sign?
ReplyDelete"<>" is sign of "not equal".
DeleteSelect ename , job , sal
ReplyDeletefrom Empl
where mgr IS NULL;
Output is :-
DeleteAMIR, PRISIDENT, 5000.00
thank u a lot. needed that too
DeleteIs it correct?
Deletemanager pe quotes bhi hone chahiye..
ReplyDeleteYes,
DeleteSelect ename , job , sal
ReplyDeletefrom Empl
where mgr IS NULL;
Can't this be the answer to this question as MGR in table stands for manager only
He was asking for output not telling us answer.
Deleteselect ename,job,sal from empl where job <>"manager";
ReplyDeletewhere is not equal to sign
ReplyDeletewho are u
Delete<> is sign of not equal to sign.
DeleteI am PathWalla 😁
<>?
ReplyDeleteIt mean "not equal".
Deletewe can also write like this select ename,job,sal from empl where job not in manager
ReplyDeleteWhy <> this symbol ?
ReplyDeleteNOT EQUAL
Delete
ReplyDelete)Increment the salary of all clerks by 25/-.
Wrong answer
ReplyDeleteIt should be --> select ename, job, sal from Empl where mgr is Null;
bro but in paper we can write the syblol of not equal to right?
ReplyDeletePost a Comment
You can help us by Clicking on ads. ^_^
Please do not send spam comment : )