Interested to Buy Any Domain ? << Click Here >> for more details...
How to fetch records from a partitioned table?
- 2 Answers
- 8190 Views
- HSBC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
select * from tabe_name partition (partition_name );
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / santosh kumar
SELECT * FROM TABLENAME PARTITION(PMONHTYEAR)
EX:
SELECT * FROM SALARY PARTITION(P0315)
| Is This Answer Correct ? | 1 Yes | 0 No |
What is database sql?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
Can we use ddl statements in stored procedure?
What is int identity in sql?
how to retrive only second row from table?
How subquery works in sql?
What is extent clause in table space?
how will be date change into string
How do I run a program in pl sql?
what tools available for managing mysql server? : Sql dba
How can you save or place your msg in a table?
How can multiply values of a column? OR How can multiply value of a row of a column using a single query in SQL?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
