CodeEra

CodeEra

Hello dear viewers!!!
Firstly thank you so much for visiting my channel.
Here you will get free technical tutorials on the technology and languages to include C, C++, Java, Html, CSS, MySQL, Oracle DB, DBMS, data structure, and many more.

My intention behind making this channel is to provide free education to everyone so that they can upgrade themselves with new technology and their concepts.

I always tried to make videos more easy and understanding. If my channel and videos help you to get knowledge and improve your skills. so just hit the subscribe button and for latest video press bell icon and don't forget to like videos.

Join us on Telegram- t.me/joingroupCodeEra
Follow us on Instagram - instagram.com/codeera_/

Пікірлер

  • @sandhyalavudya9347
    @sandhyalavudya93477 сағат бұрын

    select id,name, date_sub(dob,interval 3 years) as update_date_of_birth from employees

  • @sandeeptripurana4496
    @sandeeptripurana449621 сағат бұрын

    Good one

  • @diyadeb
    @diyadebКүн бұрын

    Isme toh mam duplicate entry ke vaja se error aa raha hai

  • @PranayNaranje-iu9gg
    @PranayNaranje-iu9gg2 күн бұрын

    You are explaining in my sql

  • @Anushree350
    @Anushree3503 күн бұрын

    mam can you make vedios on views , window functions , rank .......................,,like advance topics please 🙂🙂🙂🙂🙂🙂🙂🙂

  • @RaviTejaMeruva
    @RaviTejaMeruva4 күн бұрын

    Excellent Explanation

  • @tanishtha-dj1wu
    @tanishtha-dj1wu4 күн бұрын

    I answered wrong in puzzle.Except that everything was fine in my digital interview.Will they reject me on that basis??

  • @rneditz3250
    @rneditz32504 күн бұрын

    Are this tables are given in our interview rounds while asking query to us????

  • @SadabKhan-zd9ts
    @SadabKhan-zd9ts10 күн бұрын

    This same question how to solve subquery please tell me mam

  • @bluesparrow2.027
    @bluesparrow2.02711 күн бұрын

    Hi saloni me interview me join ki query me bar bar fail ho rha ab mujhe smjh nhi aa rha h kya kru

  • @poojam271
    @poojam27111 күн бұрын

    Thank You so much Mam

  • @great.Indian.culture
    @great.Indian.culture11 күн бұрын

    Thanks sister best and easiest explanation

  • @VigneshVeravalli229
    @VigneshVeravalli22913 күн бұрын

    hi saloni

  • @adityarajbhandare5166
    @adityarajbhandare516615 күн бұрын

    SELECT C.prod_id, A.cust_name, A.cust_city, B.order_date, C.prod_price FROM customers as A INNER JOIN orders as B ON c.cust_id = o.cust_id INNER JOIN product_details as P ON B.order_id = C.order_id WHERE A.cust_name = 'David';

  • @chfadi2201
    @chfadi220115 күн бұрын

    Thank you sooo much ❤❤❤❤

  • @allurianusha6111
    @allurianusha611118 күн бұрын

    Excellent teaching skills 😊

  • @talknow2859
    @talknow285920 күн бұрын

    You're amazing 🎉!

  • @user-dt8dg9qf7f
    @user-dt8dg9qf7f22 күн бұрын

    channel owner disappeared or not in mood to reply

  • @akashbasak1759
    @akashbasak175922 күн бұрын

    in the first question if there are duplicates of highest salary and if we put a limit, then after sorting how can the third row will be having the third highest salary? my approach using a distinct keyword select * from employeeinfo where salary=(select * from (select distinct(salary) from employeeinfo) as e1 order by age desc limit 2,1); correct me if I am wrong Thank You

  • @ptechsolutions9575
    @ptechsolutions957523 күн бұрын

    Very helpful

  • @vijay_madane03
    @vijay_madane0323 күн бұрын

    Top clause is not working in MySQL workbench

  • @AgyatBihari
    @AgyatBihari18 күн бұрын

    It will not work, in MySQL limit and offset will work

  • @amevegeta
    @amevegeta24 күн бұрын

    Hi Saloni i want to subtract date from 2 different columns and want the output in days but it is not working kindly suggest

  • @vijay_madane03
    @vijay_madane0326 күн бұрын

    Except is not working in SQL workbench please reply.

  • @snehalgajbhiye1454
    @snehalgajbhiye145426 күн бұрын

    Thank you so much saloni😊

  • @user-lf6lg5yg7e
    @user-lf6lg5yg7e26 күн бұрын

    create on how to delete duplicate rows;

  • @user-lf6lg5yg7e
    @user-lf6lg5yg7e26 күн бұрын

    finally my doubt cleared in simple way very thanks hope you upload this kind of videos which are helpful

  • @smileuntilyoudie5127
    @smileuntilyoudie512727 күн бұрын

    Very Nice and helpfull questions

  • @harivas7067
    @harivas706727 күн бұрын

    I have done the same but it is not executing 😑.

  • @RaviPandey-ng8ub
    @RaviPandey-ng8ub28 күн бұрын

    I have my TCS nqt interview in the upcoming week. This video helps me a lot

  • @p.nandakishorreddy2215
    @p.nandakishorreddy221512 күн бұрын

    did you completed your interview

  • @xikusyaa
    @xikusyaa28 күн бұрын

    0:32 only database with same id assigned to multiple employees

  • @burinyuybongfen7857
    @burinyuybongfen785729 күн бұрын

    Beautifully explained

  • @balaroxx2700
    @balaroxx270029 күн бұрын

    The result is not acceptable mam sincd the salary should by greater than 5000 there are onlyone in accounting and two in developer having salary more than 5000 but the result showing wrong answer 7:24

  • @harshitsaxena7205
    @harshitsaxena7205Ай бұрын

    select * from practise1 where EmpLname Like '_%a' and length(EmpLname)=5; last vali query in better way!!

  • @wasimkotwal1889
    @wasimkotwal1889Ай бұрын

    Excellent ..unbeatable on KZread.. I'm a big SQL fiyan of yours ..using ur channel now working as a senior developer

  • @talknow2859
    @talknow2859Ай бұрын

    Saloni, all your videos are fantastic 👏 👌 🎉. I must admit that this where I finally learnt SQL principles. Very detailed work. Thank you 🙏

  • @harshkumargupta8538
    @harshkumargupta8538Ай бұрын

    quality video.

  • @techinicalocean8733
    @techinicalocean8733Ай бұрын

    You are great 👍

  • @Vaishnavikaithwas786
    @Vaishnavikaithwas786Ай бұрын

    Really, superb explaination mam.... Crystal clear

  • @ponkarthickkumarl1655
    @ponkarthickkumarl1655Ай бұрын

    Can i use full outer join for 1 and 2 questions

  • @vijay_madane03
    @vijay_madane03Ай бұрын

    Left join kyu use Kiya he samja nhi..

  • @hafizzuhairallinone3047
    @hafizzuhairallinone3047Ай бұрын

    please provide all slides of this course playlist

  • @habibpatoana2931
    @habibpatoana2931Ай бұрын

    Thanks! Mam, Excellent

  • @bartosz3667
    @bartosz3667Ай бұрын

    System engineer post??? That too after asking topic related to latest technologies and coding.

  • @krishnakantvishwakarma3600
    @krishnakantvishwakarma3600Ай бұрын

    Its TCS roles, but its not specific you will be working as system engineer, you will get any works Developer,test, support

  • @kakkaladeepak632
    @kakkaladeepak632Ай бұрын

    thanks a lot man

  • @cxyax_1234
    @cxyax_1234Ай бұрын

    Very easy explanation. Very helpful 😊

  • @mohamedhizam7398
    @mohamedhizam7398Ай бұрын

    Xampp

  • @PavanKumar-vt2fj
    @PavanKumar-vt2fjАй бұрын

    Every video is good except this video 90% of this video seems to be like u r reading a newspaper, please explain clearly if possible.... Anyway I like ur explanation in all other videos

  • @Tech.S7
    @Tech.S7Ай бұрын

    Simple very short ways.... Explained like a pro... Layman can also understand..... Good teaching 🙏

  • @raviteja4660
    @raviteja4660Ай бұрын

    Plz explain about many to many relationships in mysql

  • @prasannas439
    @prasannas439Ай бұрын

    How to know the here we use left join here we use right join to know that