I am having a table which is having more than 2 billion rows. The count is 2439371821
The table is not having a primary key colomns.
I need to create 2 view, The first view gets the 50% of the rowsand second view gets the next 50% of the rows.
Example : if the table is having 75 rows, i need to create a 2 views.
First view should return 37 rows and second view should return 38 rows.
My table is not having any primary key colomuns