adspace


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 do I remove duplicates in two columns?

1202


What is the current version of postgresql?

1188


If a cursor is open, how can we find in a pl/sql block?

1252


Is primary key clustered index?

1026


what is schema? : Sql dba

1163


how to use regular expression in pattern match conditions? : Sql dba

1125


Can delete statement be rollbacked?

1065


what are the advantages of sql ? : Sql dba

1153


what is bcp? When does it used? : Sql dba

1065


define sql insert statement ? : Sql dba

1108


What is the best sql course?

1062


Is primary key always clustered index?

1101


Do we need to rebuild index after truncate?

1151


What is the current version of sql?

1106


Can we rollback truncate?

1083