Explain basic SQL queries with SELECT from where Order By,
Group By-Having?

Answer Posted / nitin

sory i m satisfied with idea.actualy i want to know is this
query is right or not.plz inform me.

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

Is This Answer Correct ?    7 Yes 19 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the openxml statement in sql server?

620


What are different types of raid levels?

638


What is a subquery in a select query statement in ms sql server?

693


Give a example to search fr a string in all stored procedure in sql server.

621


optimization techinques

2290






How do you handle datasets larger than 50 gb?

146


What is the process of normalising?

689


What is a dataset and what are the different types of datasets?

97


Why should one not prefix user stored procedures with ‘sp_’?

695


How can you list all the columns in a database?

621


How to run queries with sql server management studio express?

664


How many types of cursor type are there?

664


What is a bit datatype?

651


What are types of subqueries?

638


What does normalization do to data?

633