Interested to Buy Any Domain ? << Click Here >> for more details...
Can Having clause be used without Group by clause?
- 6 Answers
- 43322 Views
- CarrizalSoft Technologies, CSC, CTS, I also Faced
- E-Mail Answers
Answer Posted / pradip jain
select max(empno) from dbo.Employee having count(EmpNo)=9
it has no meaning so it will show zero record
| Is This Answer Correct ? | 17 Yes | 6 No |
Post New Answer View All Answers
What is a trace frag?
Can coalesce return null?
How to test values returned by a subquery with the in operator?
How to list all user names in a database?
Can I delete event logs?
How can you check the level of fragmentation on a table?
What is the difference between resultset and resultsetmetadata?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
How to rename an existing column with sql server management studio?
What is encryption key?
How to provide default values to function parameters?
Explain user defined views?
How can windows applications connect to sql servers via odbc?
What is a matrix in ssrs?
