1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / nitin

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

How many full-text indexes can a table have?

544

What is an inner join?

523

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

109

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1497

What is indexing in sql server with example?

511




What is shrink log file?

503

Explain transaction server implicit?

513

define and explain the differences between clustered and non-clustered indexes.

590

What is the difference between truncate and delete commands?

556

What is measure group, measure? : sql server analysis services, ssas

541

Does partitioning ssd reduce performance?

481

how will add additional conditions in sql?

569

Can a unique index be created on a column, which contains null?

515

How to create view in stored procedure sql server?

495

What is sql server management studio? : sql server management studio

574