Need help with basic sql oracle queries?

paganini

I've got a table, lets say table name is A and inside there's "date" column and "order name" column. How to retrieve the order for the last 45 days without knowing what're the dates inside the column?

OraMaster

Quote:

Originally Posted by paganini

I've got a table, lets say table name is A and inside there's "date" column and "order name" column. How to retrieve the order for the last 45 days without knowing what're the dates inside the column?

Pls check below SQL

Expand|Select|Wrap|Line Numbers

 SELECT ROWNUM, od.*

  FROM (SELECT   *

            FROM orderdtls

        ORDER BY orderdate DESC) od

 WHERE orderdate <= SYSDATE AND ROWNUM <= 45

Let me know if any issues with above SQL.

amitpatel66

Try This:

Expand|Select|Wrap|Line Numbers

  
SELECT * FROM order_details WHERE TRUNC(order_date) >= TRUNC(SYSDATE) - 45;

debasisdas

Quote:

Originally Posted by OraMaster

Pls check below SQL

Expand|Select|Wrap|Line Numbers

 SELECT ROWNUM, od.*

  FROM (SELECT   *

            FROM orderdtls

        ORDER BY orderdate DESC) od

 WHERE orderdate <= SYSDATE AND ROWNUM <= 45

Let me know if any issues with above SQL.

why use rownum ?

Question is not to retrieve last 45 records but of data of last 45 days.
There may be more that one entry in the database per day.

How rownum will help in that scenario ?

Need help with basic sql oracle queries?

re: Need help with basic sql oracle queries?

re: Need help with basic sql oracle queries?

re: Need help with basic sql oracle queries?

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about