How to fetch records from a partitioned table?

Answers were Sorted based on User's Feedback



How to fetch records from a partitioned table?..

Answer / nitinsharma06

select * from tabe_name partition (partition_name );

Is This Answer Correct ?    3 Yes 0 No

How to fetch records from a partitioned table?..

Answer / santosh kumar

SELECT * FROM TABLENAME PARTITION(PMONHTYEAR)
EX:

SELECT * FROM SALARY PARTITION(P0315)

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

How can we make an if statement within a select statement?

0 Answers  


What are the different operators available in sql?

0 Answers  


How do you concatenate in sql?

0 Answers  


What are the types of records?

0 Answers  


how are mysql timestamps seen to a user? : Sql dba

0 Answers  






how to calculate expressions with sql statements? : Sql dba

0 Answers  


what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

0 Answers  


Can we use view in stored procedure?

0 Answers  


what are the different type of sql's statements ? : Sql dba

0 Answers  


Is sql better than excel?

0 Answers  


Difference between views and materialized views?

5 Answers   BirlaSoft,


What is the benefit of foreign key?

0 Answers  


Categories