Ask questions which are clear, concise and easy to understand.
Ask QuestionPosted by Ranbir Trikha 6 years, 2 months ago
- 1 answers
Posted by Aashish Bhanushali 6 years, 2 months ago
- 0 answers
Posted by Arpita Rajput 6 years, 2 months ago
- 1 answers
Vaishali Misra 6 years, 2 months ago
Posted by Priyanshu Verma 3 years, 5 months ago
- 1 answers
Sia ? 3 years, 5 months ago
| SR.NO. | WHERE Clause | HAVING Clause |
| 1. | WHERE Clause is used to filter the records from the table based on the specified condition. | HAVING Clause is used to filter record from the groups based on the specified condition. |
| 2. | WHERE Clause can be used without GROUP BY Clause | HAVING Clause cannot be used without GROUP BY Clause |
| 3. | WHERE Clause implements in row operations | HAVING Clause implements in column operation |
| 4. | WHERE Clause cannot contain aggregate function | HAVING Clause can contain aggregate function |
| 5. | WHERE Clause can be used with SELECT, UPDATE, DELETE statement. | HAVING Clause can only be used with SELECT statement. |
| 6. | WHERE Clause is used before GROUP BY Clause | HAVING Clause is used after GROUP BY Clause |
| 7. | WHERE Clause is used with single row function like UPPER, LOWER etc. | HAVING Clause is used with multiple row function like SUM, COUNT etc. |
Posted by Sakshi Dongre 6 years, 2 months ago
- 0 answers
Posted by Lekshmi Vinod 6 years, 2 months ago
- 0 answers
Posted by Vanita Sen 6 years, 2 months ago
- 0 answers
Posted by Madhav Agarwal 6 years, 2 months ago
- 0 answers
Posted by Md Aman 6 years, 2 months ago
- 0 answers
Posted by Rupesh Singh 6 years, 3 months ago
- 0 answers
Posted by Dharmesh Gohel 6 years, 3 months ago
- 0 answers
Posted by Archit Rajesh 6 years, 3 months ago
- 0 answers
Posted by Kartik Rai 6 years, 3 months ago
- 0 answers
Posted by Shivam Namdev 6 years, 3 months ago
- 0 answers
Posted by Suruchi Chaudhary 6 years, 3 months ago
- 0 answers
Posted by Chandra Sree Gandhavarapu 3 years, 5 months ago
- 1 answers
Sia ? 3 years, 5 months ago
| 1. | Bridge works in data link layer. | While it works in all layer. |
| 2. | Bridge connects two different LANs. | While it converts the protocol. |
| 3. | Bridge connects two different LAN working on same protocol. | While gateway will settle for and transfer the packet across networks employing a completely different protocol. |
| 4. | In bridge, data or information is in the form of packet. | Whereas in gateway, data or information is also in the form of packet. |
| 5. | In bridge, format of packet is not changed. | While in gateway, format of packet is changed. |
| 6. | Bridge is not installed in router. | While it installed in router. |
Posted by Rahul Raj 6 years, 4 months ago
- 1 answers
Zahir Bashir 6 years, 4 months ago
Posted by Sourav Singh 6 years, 4 months ago
- 1 answers
Richa Sharma 6 years ago
Posted by Subhash Kumar 6 years, 4 months ago
- 0 answers
Posted by Chitra Sharma 6 years, 4 months ago
- 0 answers
Posted by Neerav Sharma 6 years, 4 months ago
- 0 answers
Posted by Sakshi Singh 6 years, 4 months ago
- 0 answers
Posted by Arathi Ramachandran 6 years, 5 months ago
- 0 answers
Posted by Shobha Ajjankatti 6 years, 5 months ago
- 0 answers
Posted by Sudarshan Tayal 6 years, 5 months ago
- 0 answers
Posted by Deepak Singh 6 years, 5 months ago
- 0 answers
Posted by Deepak Singh 6 years, 5 months ago
- 1 answers
Posted by K Rahul Kumar 6 years, 5 months ago
- 0 answers
myCBSEguide
Trusted by 1 Crore+ Students
Test Generator
Create papers online. It's FREE.
CUET Mock Tests
75,000+ questions to practice only on myCBSEguide app
Diksha Gupta 6 years, 2 months ago
1Thank You