very informational video keep it up

little bit easy approach =select * from phonenum_vali where length(regexp_replace(phone_num,'[^0-9]',null))=10;

Good Explanation and very helpful, please post more videos

We can write the query without using inner query Select rtrim(sum(salary),0) as sal from table_name

Thanks fr video. In theritical qn,Why answer no. If u r explained that, it will helpful

@Geekpeakstudio

Жыл бұрын

we will explain each and every topic. Thank you for the feedback

Can you please share the data set to practice those question

Inner join returns common result

@Geekpeakstudio

9 ай бұрын

Absolutely ,an inner join returns only the rows that have matching values in both tables being joined. Inner joins are typically used to combine data from multiple tables based on a specified condition, such as matching values in a common column.

can you share us the sheet which you are doin query pls

We can write the query without using inner query Select rtrim(sum(salary),0) as sal from table_name