Explain basic SQL queries with SELECT from where Order By,
Group By-Having?
Answer Posted / ranjan
In above select stmnt city must be in group by clause. Otherwise it'll sho error.
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are the steps to follow to configure SQL*Net?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
What is Command line parameters in PLSQL.?
what is the sql equivaent of the dataset relation object ?
What is cube dimension? : sql server analysis services, ssas
How to Check if table exists in sql server?
Give me a SQL Query to find out the second largest company?
Explain linked server in sql?
Give a example to search fr a string in all stored procedure in sql server.
Do you know what are acid properties of transaction?
What is the difference between for auto and for nested?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
What is the sql case statement used for? Explain with an example?
What are the types of subscriptions in SQL Server replication?
What is ms sql server index?