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

Can we perform backup restore operation on tempdb?

571

How adventureworkslt tables are related?

533

What is scan table/view and seek table/view when its occurs? : sql server database administration

539

What is msdb database? : SQL Server Architecture

541

Does group by sort data?

514




How many full-text indexes can a table have?

555

Where are full-text indexes stored?

575

What is data modification?

513

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

535

How can you start sql server in different modes?

509

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

571

What is SQL Azure Fabric?

92

What is triggers in ms sql server?

640

Explain the rules for designing files and file groups in sql server?

552

Explain what are the authentication modes in sql server?

502