How to run a sql statement?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More MySQL Interview Questions

How many sql ddl commands are supported by 'mysql'?

0 Answers  


I want to make a query where I want to eliminate the duplicate rows from the table. For example : Input : Table : NAME Column1 Column2 India USA USA India UK India India UK The desired output that I want to eliminate the duplicates Output India USA UK India Thanks

2 Answers   Sun Life,


How do you flush privileges?

0 Answers  


why we are join a tow table

1 Answers  


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

0 Answers  






What is ntext?

0 Answers  


How to concatenate two character strings?

0 Answers  


date funciton

2 Answers  


Why mysql is so popular?

0 Answers  


How to change a password for an existing user via mysqladmin?

0 Answers  


How to check if a record exists in a mysql database php?

0 Answers  


SQL: 1. Write a queryto retrieve the author who was published a book at the youngest age? 2. write a query to retrieve the no. of books published a each year in various languages? 3. write a query to retrieve no. of books published by them only those authors who have published more than 1 book? 4. write a query to retrieve who has not published any books during the year 2006? 5. write a query to retrieve the authors who has published any books during the birth date write this query in 2 ways 1)joins 2)sub query 6. write a query to retrieve all the books which was published during jan 2007 & title containing India or published in the language hindi? 1. table name is liberary managemnt and two column is there one is authors and another one is books . 2.four fields will comes under authours like nationality, birthdate ,first-language,second-language 3.four fields will comes under books like authour,title ,language,publish date to write query using this details

4 Answers   Covansys,


Categories