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
What is report rendering ?
What’s the distinction between dropping a info and taking a info offline?
What are .mdf files?
What is implicit mode in sql server?
What happens if you delete a table that is used by a view?
Can a unique index be created on a column, which contains null?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
What is the log shipping?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
What is the recovery model? List the types of recovery model available in sql server?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
What is a db view?
Why functions are used in sql server?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What is data modeling and Reterminal integrity?