Interested to Buy Any Domain ? << Click Here >> for more details...
Explain basic SQL queries with SELECT from where Order By,
Group By-Having?
- 3 Answers
- 21595 Views
- TetraSoft, Wipro, I also Faced
- E-Mail Answers
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
what stored procedure would you use to view lock information? : Sql server administration
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
What happens when the SQL Azure database reaches Max Size?
Explain “row_number()” in sql server with an example?
What is scheduled job and how to create it?
What is report snapshot in ssrs?
How to create a scrollable cursor with the scroll option?
what types of replication are supported in sql server? : Sql server database administration
Can a database be shrunk to 0 bytes, if not, why?
what is the difference between a primary key and a unique key? : Sql server database administration
What is an execution plan?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
How you would rewrite the sql query to return the customerid sorted numerically?
Mention the command used to rename the database.
