10 Comments

    select * FROM orders
    WHERE OrderDate BETWEEN ‘1996-07-04 and ‘1996-07-09’;

    SELECT * FROM Orders where OrderDate between #07/04/1996# and #07/09/1996#;

    FOR ORACLE – 10G QUERY WILL BE —-

    SELECT * FROM ORDERS WHERE ORDERDATE BETWEEN TO_DATE(’04/07/1996′,’MM/DD/YYYY’) AND TO_DATE(’09/07/1996′,’MM/DD/YYYY’);

    select * from orders where orderdate between #07/04/1996# and #07/09/1996#;

    SELECT * FROM Orders where OrderDate between #07/04/1996# and #07/09/1996#;

    select * from orders where orderdate between ’04-july-1996 and 09-july-1996′

    Select * from orders where orderDate between #07/04/1996# and # 07/09/1996#;

    SELECT * FROM Orders where OrderDate between ‘1996-07-04’ and ‘1996-07-09’;

    SELECT * FROM Orders where OrderDate between ‘1996-07-04’ and ‘1996-07-09’;

    SELECT * FROM Orders WHERE OrderDate BETWEEN ‘1996-07-04’ AND ‘1996-07-09’;

Leave a Reply

Loading Questions

If you are facing any issue like can not see video so please login into Google with email what you forwarded to us Google Login or mail to administrator qatraining@infotek-solutions.com