Any one tell about this query. In table below 7566 empno is add it's showing nothing

Question

select * from employee where empno<=7566 AND empno>= 7788

Answer 1

cause its a wrong query, you ask the database to select numbers that are greater than 7788 and less than 7566...😉

Answer 2

thanks