General information
Category:
Coding, syntax & commands
If you need a new tableB, then:
copy next 30 to tableB
If you need to append to tableB, then you may copy to temporary table and then append from it to tableB
>Is there a way that I can select only X amount of records from a table and put them into another table?
>
>Ex.
>TableA has 779696 number of records and is sorted by datetime desc
>I only want the first 30 records and want them in TableB
>What is the best way to do this?
>
>TIA!
Previous
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