Answer Posted / shailesh yadav

Yes HAVING caluse can be use without GROUP BY. the SQL HAVING clause is often used with the GROUP BY clause. If the GROUP BY clause is omitted, the MySQL HAVING clause behaves like the WHERE clause. Notice that the MySQL HAVING clause applies the condition to each group of rows, while the WHERE clause applies the condition to each individual row.

Is it safe to delete log files?

867

---

How to view existing indexes on an given table using sp_help?

1053

---

How can a user-defined datatype be created?

935

---

how to take backup bcp out for a column in table in sql server?

2043

---

Define Wed Edition in SQL Azure?

100

---

How can change procedure in sql server?

985

---

Will count(column) include columns with null values in its count?

1032

---

What happens on checkpoint?

966

---

How to delete an existing row with delete statements in ms sql server?

1018

---

What is exporting and importing utility?

1016

---

Does view occupy space?

884

---

What is cube dimension? : sql server analysis services, ssas

954

---

What is oltp (online transaction processing)?

950

---

Do you know the cursor optimization tips?

929

---

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1623

---