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
- 21755 Views
- TetraSoft, Wipro, I also Faced
- E-Mail Answers
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
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
How do I open a .db file?
What is t-sql script to take database offline – take database online.
What is the syntax for encrypting a column in SQL Server?
Explain syntax for viewing trigger?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
Explain different types of index?
what are user defined datatypes? : Sql server database administration
What happens if null values are involved in string operations?
what's the difference between a primary key and a unique key? : Sql server database administration
what kind of lan types do you know? : Sql server database administration
Which tcp/ip port does sql server run on? How can it be changed?
What is acid mean in sql server?
Explain the dbcc pintable command when would you use it?
What is a field name?
