Can Having clause be used without Group by clause?
- 6 Answers
- 41599 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
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
Explain optimistic and pessimistic concurrency?
Explain the concept of view and Types of views in SQL server?
Name few of the dcl commands in sql?
how can u get last observation in an unknown dataset ?
How to verify a user name with sqlcmd tool?
What is coalesce in sql server?
plss anybody specify tha constrian management system in dbms
Explain temporary table vs table variable by using cursor alternative?
What is the purpose of object explorer and its features? : sql server management studio
What are various limitations of the views?
What is the architecture of ms sql reporting service?
What is a database in ms sql server?
How can you insert values in multiple rows using one Insert statement?
Explain ranking functions?
