Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

For the database from the previous question, please give an
SQL query which returns the invoice number of all invoices
which contain the article with the number ?1234?. The query
should be able to run under a MySQL 4.0 database.

Question Posted / pranab


For the database from the previous question, please give an SQL query which returns the invoice nu..

Answer / frank

SELECT invoiceNumber FROM invoices i INNER JOIN articles a
ON i.articleId=a.articleId WHERE article LIKE '%1234%';

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

How do I connect to a database in mysql workbench?

0 Answers  

What is the maximum size of table in mysql?

0 Answers  

What is row level locking?

0 Answers  

What is the password of mysql?

0 Answers  

what is cte? : Mysql dba

0 Answers  

What tools available for managing mysql server?

0 Answers  

What is the difference between mysql_fetch_array() and ysql_fetch_object() ?

0 Answers  

What is new mysqli?

0 Answers  

SELECT country,city FROM customers GROUP BY country ORDER BY city DESC

5 Answers   HCL,

What is the difference between mysql and sql?

0 Answers  

in a master-master replication with two masters and alternate slaves running on two systems.can i have a script or any mysql command to know which one is right now acting as master.

1 Answers  

How do I run mysql from command line?

0 Answers  

For more MySQL Interview Questions Click Here
Categories