Junilu Lacar wrote:
in "Clean Code," Robert Martin wrote:
It is sometimes reasonable to leave “To do” notes in the form of //TODO comments. ... Still, you don’t want your code to be littered with TODOs. So scan through them regularly and eliminate the ones you can.
Hmm... either you've misunderstood what he wrote (emphasis mine) or you're referring to some other passage in the book.
Multiple rows have the maximum value for salary, so how can the DBMS know which value to return.
And your example query is illegal in standard SQL
If you didn't have to take the employment status into account