Assume If u have employee table. U have to fetch the results whose salary is greater than 5000. Without using where clause.

Question

In MySQL query how to fetch employee table whose salary is greater than 5000 Without using where clause..pls tell me the solution

Answer 1

Why without 'Where'?

Answer 2

actually I did using having clause.But some one says having clause only applicable for if we use group by clause..so how we can acheive this one

Answer 3

Asking interview question