select * from tabe_name partition (partition

How to fetch records from a partitioned table?

Question Posted / nitinsharma06

Answer Posted / nitinsharma06

select * from tabe_name partition (partition_name );

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What sql does db2 use?

934

How bulk collect improves performance?

958

how to create a new view in mysql? : Sql dba

904

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

917

What is numeric function sql?

1001

Why procedure is used in sql?

986

What is varchar used for?

1034

Why we use join in sql?

921

Why we use pl sql?

915

What is the execution plan in sql?

980

How do you sort in sql?

965

How delete a row in sql?

938

What is consistency?

1073

What is data profiling in sql?

1024

Is pl sql useful?

941