How can we import a subset of rows from a table without using the where clause?

 We can run a filtering query on the database and save the result to a temporary table in database.

Then use the sqoop import command without using the –where clause