How to evaluate employee wages rise to 10% before the SQL statement
Two table
Postsalary:

Emp:

CodePudding user response:

 select * from emp where exists 
(select 1 from postsalary where postsalary. Empid=emp. The empid and postsalary. Pastsalary * 1.1=emp. The salary) 

CodePudding user response:

reference 1st floor weixin_41985389 response:

 select * from emp where exists 
(select 1 from postsalary where postsalary. Empid=emp. The empid and postsalary. Pastsalary * 1.1=emp. The salary) 

Tried, the result is like this:

May be the result of my database table the same, but better now.thanks!

I later changed:
The SELECT e.e mpid, e.e mpname, e.s alary, supachai panitchpakdi astsalary from myuser. The emp as e,
Myuser. Postsalary as s where supachai panitchpakdi astsalary * 1.1 & lt;=e.s alary and e.e mpid=s.e mpid;

Kuo to, I first think of complicated , the whole some at sixes and sevens, harm!

CodePudding user response:

Thought you as long as 10%, should be to go up & gt;=10%

CodePudding user response:

reference weixin_41985389 reply: 3/f

thought you as long as 10%, should be to go up & gt;=10%

Yes yes, write nasty (but can't find [cry laugh] expression)

CodePudding user response:

suggest to learn hump nomenclature

CodePudding user response:

reference 5 floor weixin_41985389 reply:

suggest to learn hump nomenclature

Yes, yes, I really see shall not be named