Ask questions which are clear, concise and easy to understand.
Ask QuestionPosted by Arpita Rajput 7 years, 1 month ago
- 1 answers
Posted by Priyanshu Verma 4 years, 4 months ago
- 1 answers
Sia ? 4 years, 4 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 7 years, 1 month ago
- 0 answers
Posted by Lekshmi Vinod 7 years, 1 month ago
- 0 answers
Posted by Vanita Sen 7 years, 1 month ago
- 0 answers
Posted by Madhav Agarwal 7 years, 1 month ago
- 0 answers
Posted by Md Aman 7 years, 2 months ago
- 0 answers
Posted by Rupesh Singh 7 years, 2 months ago
- 0 answers
Posted by Dharmesh Gohel 7 years, 2 months ago
- 0 answers
Posted by Archit Rajesh 7 years, 2 months ago
- 0 answers
Posted by Kartik Rai 7 years, 2 months ago
- 0 answers
Posted by Shivam Namdev 7 years, 2 months ago
- 0 answers
Posted by Suruchi Chaudhary 7 years, 2 months ago
- 0 answers
Posted by Chandra Sree Gandhavarapu 4 years, 4 months ago
- 1 answers
Sia ? 4 years, 4 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 7 years, 3 months ago
- 1 answers
Zahir Bashir 7 years, 3 months ago
Posted by Sourav Singh 7 years, 3 months ago
- 1 answers
Richa Sharma 6 years, 11 months ago
Posted by Subhash Kumar 7 years, 3 months ago
- 0 answers
Posted by Chitra Sharma 7 years, 3 months ago
- 0 answers
Posted by Neerav Sharma 7 years, 3 months ago
- 0 answers
Posted by Sakshi Singh 7 years, 4 months ago
- 0 answers
Posted by Arathi Ramachandran 7 years, 4 months ago
- 0 answers
Posted by Shobha Ajjankatti 7 years, 4 months ago
- 0 answers
Posted by Sudarshan Tayal 7 years, 4 months ago
- 0 answers
Posted by Deepak Singh 7 years, 4 months ago
- 0 answers
Posted by Deepak Singh 7 years, 4 months ago
- 1 answers
Posted by K Rahul Kumar 7 years, 4 months ago
- 0 answers
Posted by Deepak Singh 7 years, 4 months ago
- 0 answers
Posted by Ravishankar Kumar 7 years, 4 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
Vaishali Misra 7 years, 1 month ago
0Thank You