When you need to apply a minor tweak to the document, it must not take long to Locate table record. Such a simple activity does not have to demand extra training or running through handbooks to understand it. With the right document modifying tool, you will not spend more time than is needed for such a quick change. Use DocHub to simplify your modifying process regardless if you are an experienced user or if it is your first time making use of an online editor service. This instrument will take minutes or so to learn to Locate table record. The sole thing required to get more effective with editing is actually a DocHub account.
A plain document editor like DocHub can help you optimize the amount of time you need to dedicate to document modifying irrespective of your prior experience with this kind of tools. Make an account now and improve your productivity immediately with DocHub!
welcome to this sql interview series of data millennials in this video we are going to discuss about our next question in sql interview series so the question is that we have to write a sql query to find the records in table a that are not present in table b but there is a condition that you do not have to use the not in operator now not in operator is usually used to find out the record which is not present in another table but when your interviewer has specifically asked you to not use this not in operator then there are two options that you can use the first one is that you can use joins and the second one is that you can use not exist so you have two tables here the first table is table a which have certain numbers here and you have another table table b which have certain numbers here now if you see these two tables you will see that 40 is present in table a as well as 40 is present in table b right similarly there can be multiple reports which is present in table a which is also