How to fetch records from a partitioned table?

Question Posted / dev

2 Answers
8119 Views
HSBC, I also Faced
E-Mail Answers

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

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers

What are variables in pl sql?

0 Answers

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

0 Answers

What is the difference between delete and truncate commands?

0 Answers

What does an inner join do?

0 Answers

Give the structure of the procedure ?

1 Answers

what tools available for managing mysql server? : Sql dba