Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 7705
  • 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

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

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