How to fetch records from a partitioned table?
Answers were Sorted based on User's Feedback
select * from tabe_name partition (partition_name );
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / santosh kumar
SELECT * FROM TABLENAME PARTITION(PMONHTYEAR)
EX:
SELECT * FROM SALARY PARTITION(P0315)
Is This Answer Correct ? | 1 Yes | 0 No |
How can we make an if statement within a select statement?
What are the different operators available in sql?
How do you concatenate in sql?
What are the types of records?
how are mysql timestamps seen to a user? : Sql dba
how to calculate expressions with sql statements? : Sql dba
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
Can we use view in stored procedure?
what are the different type of sql's statements ? : Sql dba
Is sql better than excel?
Difference between views and materialized views?
What is the benefit of foreign key?