• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 7707
  • Last Modified:

how to select data from a particular partition

hi
i have a table with 5 partitions.

now i  want something like this.

select * from table_name (from partition 3).

how to do this ?
0
vishali_vishu
Asked:
vishali_vishu
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
simply like this:
select * from table_name partition(3)

Open in new window

0
 
Mark GeerlingsDatabase AdministratorCommented:
Angellll is correct, you simply include the keyword "partition" in your query, and you must use parentheses around the partition name.  You may optionally include a space between the word "partition" and the parenthesis like this:
select * from table_name partition (3)
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now