Interested to Buy Any Domain ? << Click Here >> for more details...
Can Having clause be used without Group by clause?
- 6 Answers
- 43320 Views
- CarrizalSoft Technologies, CSC, CTS, I also Faced
- E-Mail Answers
Answer Posted / phani
we can use, but select columns and having columns should
use with aggregare functions
ex:
select max(empid), min(marks)
from employee
having max(empid_id)>100
| Is This Answer Correct ? | 72 Yes | 16 No |
Post New Answer View All Answers
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
When do you think a developer should use sql server-based cursors?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
How to transfer data from a cursor to variables with a "fetch" statement?
What are a scheduled jobs?
What are the types of processing and explain each? : sql server analysis services, ssas
What are group functions in query statements in ms sql server?
How dts is used to extract, transform and consolidate data?
What is difference between getdate and sysdatetime in sql server 2008?
How we can refresh the view?
What is 'Join' and explain its various types.
Where the sql logs gets stored?
What are the hotfixes and patches in sql server?
What is logon trigger?
Is port 1433 secure?
