Interested to Buy Any Domain ? << Click Here >> for more details...
Can Having clause be used without Group by clause?
- 6 Answers
- 43601 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
Ms sql server index?
What is primary key index?
What is user-defined inline table-valued function?
What are functions in the sql server?
What the difference between UNION and UNIONALL?
What is nolock hint in sql server 2008
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
Write the queries for commands like Create Table, Delete table, Drop Table etc.
What command is used to rename the database?
What is a dbms wizard?
What are sql servers used for?
What is a synonym for manipulation?
What is acid mean in sql server?
Which database stores information about replication?
Write SQL queries on Self Join and Inner Join.
