How to fetch records from a partitioned table?
Answer Posted / santosh kumar
SELECT * FROM TABLENAME PARTITION(PMONHTYEAR)
EX:
SELECT * FROM SALARY PARTITION(P0315)
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is primary key sql?
What is rtm in testing?
Where is all the data on the internet stored?
What are sql triggers used for?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What is gpt format?
How to sort the rows in sql.
How do I start sql profiler?
What is execute immediate?
Sql technical questions
What are the 3 types of behavioral triggers?
What is execution plan in sql?
Explain mutating table error.
Why stored procedures are faster than query?
What is varchar sql?