SELECT * FROM TABLENAME PARTITION(PMONHTYEAR) EX: SELECT * FROM SALARY

How to fetch records from a partitioned table?

Question Posted / santosh kumar

Answer Posted / santosh kumar

SELECT * FROM TABLENAME PARTITION(PMONHTYEAR)
EX:

SELECT * FROM SALARY PARTITION(P0315)

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is autocommit sql?

940

how many sql ddl commands are supported by 'mysql'? : Sql dba

977

Can there be more than one function with a similar name in a pl/sql block?

937

What is the use of & in pl sql?

1003

How can I speed up sql query?

920

Where can I learn sql for free?

951

Explain select statements in sql?

1019

What is replication id?

894

What is a table?

968

What are the different types of sql commands?

1079

What is posting?

999

Is a view faster than a stored procedure?

913

Is sql harder than python?

1053

What is the difference between truncate and drop statements?

1108

Which join is like inner join?

987