ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Databases  >>  MySQL
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
SELECT country,city
FROM customers 
GROUP BY country
ORDER BY city DESC
 Question Submitted By :: Nitin
I also faced this Question!!     Rank Answer Posted By  
 
  Re: SELECT country,city FROM customers GROUP BY country ORDER BY city DESC
Answer
# 1		 
is right or not
 
Is This Answer Correct ?    3 Yes 0 No
Nitin
 
  Re: SELECT country,city FROM customers GROUP BY country ORDER BY city DESC
Answer
# 2		 
this is right coz here order by clause is at the end of 
query...
 
Is This Answer Correct ?    6 Yes 0 No
Prajakta
 
 
 
  Re: SELECT country,city FROM customers GROUP BY country ORDER BY city DESC
Answer
# 3		 
This is wrong because there is no aggregate function in the 
query when a group by clause is used.

The above query could be like:

1. SELECT country, count(city)
2. FROM customers 
3. GROUP BY country
4. ORDER BY country DESC

* Correction at line 1 & 4.
 
Is This Answer Correct ?    1 Yes 1 No
Manoj Pandey
 

 
 
 
Other MySQL Interview Questions
 
  Question Asked @ Answers
 
How can we find the number of rows in a table using MySQL?  1
How do you start and stop MySQL on Windows?  2
what are the optimization techniques for Query optimization performance issues and faster execution of queries  1
How can you do the fine tunning? ACC3
What is SERIAL data type in MySQL?  2
What is the difference between mysql_fetch_array and mysql_fetch_object? CTS2
What are some good ideas regarding user security in MySQL?  2
How do you control the max size of a HEAP table?  1
Explain federated tables? Tech-Mahindra2
What?s the difference between PRIMARY KEY and UNIQUE in MyISAM? CSS2
A select query over a large table runs very slow because of the growing number of entries in that table. What different measures could be taken to improve speed?  3
How many ways we can we find the current date using MySQL?  4
how do i list constraints in my database by using sql server2000?  1
Which storage engines support transactions in MySQL?  1
Explain multi-version concurrency control in MySQL?  2
Explain MySQL architecture?  1
What are MySQL transactions?  1
Can you save your connection settings to a conf file?  1
ru compare the 2 null values? ACC1
Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP . Zensar2
 
For more MySQL Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com