General information
Category:
Coding, syntax & commands
hi,
Assume your table is called "MyTable", and the fields are called "area" and "days". Area can have values 1, 2 and 3;and every area have 3 days 1,2 and 3, i need 800 records from day 1 + 800 from day 2 and + 800 from day 3 for area 1,2 and 3
i mean i need exactly 2400 records(randomly). from evrey area
and deleted from "mytable" when i inserted to new table.
the total must be 7200 record at new table(table2)
thanks
m.qasem
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only