Different count between "select * " and "select count(*) "

[malay_biswal]

Did you execute both of the sql statements from same user id. If no it could be there are 2 tables of same name in different schema.