TOP 5 SQL Interview Question Part 2 | 08 |

[@beedalabharathi3120]

Very nice

[@codinglake]

Thanks

[@anuragshrivastava7855]

nice video

[@codinglake]

thanks.

[@ShubhamSaha-i7o]

nice explain.

[@codinglake]

thanks

[@nigamsaha6856]

Wow very nice 😮

[@codinglake]

Thanks 😊

[@saktibiswal6445]

Learnt about the "escape" keyword used for pattern matching.

[@codinglake]

thanks.

[@MyDailyTrading10]

Last question answer this also works
Select emp id ,count(1)as num of emp from table name group by empid having count1 >1

[@codinglake]

Nice 👍

[@luvvkatara1466]

Thankyou:)

[@codinglake]

You're welcome! 😄

[@Ravikumar-gj6qw]

Why don't do in Oracle Sql or Mysql

[@codinglake]

syntax wise little bit different, focus only on logic.

[@chiraglalwani901]

@@codinglake do we require escape in mysql as well does this concept need there as wll

[@codinglake]

@ in MySQL use \ , to ignore _ as special character