Query in oracle
-
I am using two different tables products and product details . Product ID is the primary key of the products table and is the foreign key reference to the Product details table. I want to fetch only five 5 records from the products table and for each productID I need two records from the product details table. I am using oracle 9i database. Can anyone provide an effective solution to this?
-
I am using two different tables products and product details . Product ID is the primary key of the products table and is the foreign key reference to the Product details table. I want to fetch only five 5 records from the products table and for each productID I need two records from the product details table. I am using oracle 9i database. Can anyone provide an effective solution to this?
You can use rownum to limit the results. eg. : select * from blahblah where rownum < 6
Johan Lombaard Only two things are infinite, the universe and human stupidity, and I'm not sure about the former - Albert Einstein