How to fetch records from a partitioned table?

Answer Posted / nitinsharma06

select * from tabe_name partition (partition_name );

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How sql query is executed?

548


What is the difference between the repeatable read and serializable isolation levels? : Transact sql

526


What are the different types of constraints?

556


Can we use joins in subquery?

525


Is it possible to create startup or shutdown trigger for on-schema?

577






What is data modelling in sql?

515


In what condition is it good to disable a trigger?

548


what are the features and advantages of object-oriented programming? : Sql dba

538


What is transaction control language (tcl)?

627


What is the difference between microsoft sql and mysql?

502


How do I create a memory optimized filegroup?

521


What is loop in pl sql?

565


Why do we use cursors?

503


What is a schema? How is it useful in sql servers?

586


How do I run sql?

606