We help IT Professionals succeed at work.

Query on Partioning Table.

Hi

I have the  Partioning table  which contains the data of Year 2005 and 2006 , now i want to get  data of few columns from year 2005 and another few columns data from 2006 year, so how can i fire a query on the single table, whether i need to fire the two queries or is ther any way.

Please suggest.
Comment
Watch Question

Senior Developer
CERTIFIED EXPERT
Commented:

Author

Commented:
It did not solve the Problem, as my question is as follows

I have the  Partioning table  which contains the data of Year 2005 and 2006 , now i want to get  data of few columns from year 2005 and another few columns data from 2006 year, so how can i fire a query on the single table?
whether i need to use two queries to fire at a time ?

Explore More ContentExplore courses, solutions, and other research materials related to this topic.