12 сағат бұрын
12 сағат бұрын
17 сағат бұрын
17 сағат бұрын
21 сағат бұрын
14 күн бұрын
14 күн бұрын
14 күн бұрын
21 күн бұрын
21 күн бұрын
Пікірлер
@AJ-sw5hx 8 сағат бұрын
perfect explanation and a simple approach. hope you keep making the videos
@nguyenkhanhvan4810 4 күн бұрын
How 'ORDER BY name ' change the results of COUNT(*) in 3:15 ? I think ORDER BY just specify the NAME in each partition .
@nbktechworld 6 күн бұрын
Next lecture: kzbin.info/www/bejne/o4etdZWOnbhsh9E
@nbktechworld 7 күн бұрын
Next lecture: kzbin.info/www/bejne/lYGtopmuYpWrirs
@nbktechworld 7 күн бұрын
Next lecture: kzbin.info/www/bejne/e4m1fWqLabeAoKc
@nbktechworld 8 күн бұрын
Next lecture: kzbin.info/www/bejne/hYarf6N8aZpmlZY
@nbktechworld 8 күн бұрын
Next lecture: kzbin.info/www/bejne/gIebmmaPiqiNnpo
@nbktechworld 8 күн бұрын
Next lecture: kzbin.info/www/bejne/jn_bd6trqthpebs
@nbktechworld 13 күн бұрын
Next lecture: kzbin.info/www/bejne/omW9nombr8yZh7M
@nbktechworld 13 күн бұрын
Next lecture: kzbin.info/www/bejne/sHqWl3Z9nbp9iMk
@nbktechworld 13 күн бұрын
Next lecture: kzbin.info/www/bejne/pImrp62MobapqaM
@nbktechworld 15 күн бұрын
You can find part 2 here: kzbin.info/www/bejne/jKK9aaadZbeeqdk
@MK-vu4qt Ай бұрын
Awesome! Learned lots of things in this short video. Thank you! 👏
@nbktechworld Ай бұрын
🙏🙏You're welcome! See you on Discord www.nbktechworld.com/discord
@MK-vu4qt Ай бұрын
Thank you! Great explanation 👏
@nbktechworld Ай бұрын
You're welcome! See you on Discord www.nbktechworld.com/discord
@nbktechworld Ай бұрын
Don't forget to LIKE, COMMENT, and SUBSCRIBE!!!
@nbktechworld Ай бұрын
Don't forget to LIKE, COMMENT, and SUBSCRIBE!!!
@nbktechworld Ай бұрын
Don't forget to LIKE, COMMENT, and SUBSCRIBE!!!
@nbktechworld Ай бұрын
Don't forget to LIKE, COMMENT, and SUBSCRIBE!!!
@nbktechworld Ай бұрын
Don't forget to LIKE, COMMENT, and SUBSCRIBE!!!
@sheko4515 Ай бұрын
Can we have more Ruby and Rails big projects tutorials, many thanks.
@nbktechworld Ай бұрын
Don't forget to LIKE, COMMENT, and SUBSCRIBE!!!
@ace3183 Ай бұрын
the question is wrong tbh, the ceiling should have been taken instead of the floor. the median of 3 rows is 2 not 1..
@abhishekarora6571 16 күн бұрын
He is skipping 1 row, not printing 1st row...Question is correct
@nbktechworld 2 ай бұрын
Don't forget to LIKE, COMMENT, and SUBSCRIBE!!!
@nbktechworld 2 ай бұрын
Don't forget to LIKE, COMMENT, and SUBSCRIBE!!!
@nbktechworld 2 ай бұрын
Don't forget to LIKE, COMMENT, and SUBSCRIBE!!!
@marketfinds 2 ай бұрын
Nice tutorial, kept the flow going, well spoken, great content.
@oleksiipoltavets7158 2 ай бұрын
Looking forward for monday session
@nbktechworld 2 ай бұрын
thank you. see ya!!
@oleksiipoltavets7158 2 ай бұрын
I like the bootcamp from Tech World Software School, recommend to people who want to start in tech! Thanks Mart!
@ThePassionatorCode 2 ай бұрын
Bro continue this playlist. This will help us a lot to learn. Also teach tailwind in coming days. Thank you.🥰
@LuliBrazil 2 ай бұрын
Thank you for sharing your knowledge with us! 😁👍🏽 I just subscribed. Nice to meet you, cousin.
@HassanShahzad-cc9nl 3 ай бұрын
fantastic video looking forward to more of these. anything to do with joysticks and streaming video with websockets would be great
@nbktechworld 2 ай бұрын
Thank you very much. See you on Discord @ www.nbktechworld/discord
@General_bala 3 ай бұрын
Not working
@nbktechworld 3 ай бұрын
What's not working? Be specific, share your code and what your expectations are.
@BUY_YOUTUB_VIEWS_635 3 ай бұрын
You deserve more subscribers!
@evilkittyofdoom195 3 ай бұрын
Very interesting !
@dieguque 3 ай бұрын
I love how you explalin every single detail. I already suscribed to your channel. I hope you can make the videos/playlist for the Hackerrank Python problems as well.
@nbktechworld 3 ай бұрын
Thank you for the suggestion! See you on Discord @ discord.com/invite/MJwGcwcdae
@voidsmark 4 ай бұрын
just tell me pls how u use 8version of eslint at 2024? Now is flat config using by default
@nbktechworld 3 ай бұрын
Not sure what you mean. How about you ask on Discord? See you on Discord @ discord.com/invite/MJwGcwcdae
@vedanshbisht1309 4 ай бұрын
Was intuitive, thnks
@nbktechworld 4 ай бұрын
You're welcome. See you on Discord @ discord.com/invite/MJwGcwcdae
@nbktechworld 4 ай бұрын
How was it writing your first web page?
@nbktechworld 4 ай бұрын
How was it writing your first #Reactjs component?
@nosejaja 4 ай бұрын
SELECT MAX(Doctor), MAX(Professor), MAX(Singer), MAX(Actor) FROM (SELECT COUNT(*) OVER(PARTITION BY Occupation ORDER BY Name) AS row_num, IF(Occupation = 'Doctor',Name, NULL) AS Doctor, IF(Occupation = 'Professor',Name, NULL) AS Professor, IF(Occupation = 'Singer',Name, NULL) AS Singer, IF(Occupation = 'Actor',Name, NULL) AS Actor From OCCUPATIONS) AS derived_table GROUP BY row_num;
@nbktechworld 4 ай бұрын
Hi, everyone. An update: it's 2024 and I am using one of these right now. It's pretty good and I use it with Ethernet cable and plugged in USB ports. It either goes into another USB hub or directly into computer USB port. And that USB to USB C adapter is very handy, I even use it standalone.
@ShubhamSharma-ck1dz 4 ай бұрын
This is what I was looking for, Thank you so much 😌
@nbktechworld 4 ай бұрын
You're welcome! Join us on Discord @ discord.com/invite/MJwGcwcdae
@mohammedabdulraheem-webdev5055 4 ай бұрын
How can we contact I need a mentor
@nbktechworld 4 ай бұрын
Join us on Discord discord.com/invite/MJwGcwcdae and message @nbkhope there Alternatively, message me on social media such as twitter.com/nbktechworld
@saiteja3015 5 ай бұрын
why do every statement have semi colon instead of one in the end
@nbktechworld 5 ай бұрын
MySQL syntax requires semicolons. Try omitting the semicolon and see what happens. As for the changing of the delimiter when writing a stored procedure, it's due to the following: "If you use the mysql client program to define a stored program containing semicolon characters, a problem arises. By default, mysql itself recognizes the semicolon as a statement delimiter, so you must redefine the delimiter temporarily to cause mysql to pass the entire stored program definition to the server." Source: dev.mysql.com/doc/refman/8.3/en/stored-programs-defining.html
@tiagobovolin 5 ай бұрын
Thank you very much.
@nbktechworld 4 ай бұрын
You're welcome. Stop by our Discord @ discord.com/invite/MJwGcwcdae
@hiyo4415 5 ай бұрын
Thank you! It helped me a lot understanding the answer.
@nbktechworld 4 ай бұрын
You're welcome. See you on Discord discord.com/invite/MJwGcwcdae
@shafniiqbal1601 6 ай бұрын
very good explanation
@honeyworldshop 7 ай бұрын
IS it same oracle sql
@nbktechworld 6 ай бұрын
Was that question? Try in Oracle and let us know if it works the same.
@honeyworldshop 6 ай бұрын
No the solution was not working for oracle SQL
@nbktechworld 6 ай бұрын
@@honeyworldshop, let us your query and what specific errors messages you got.
@nbktechworld 6 ай бұрын
@@honeyworldshop , assuming you tried the query with the REGEXP, I tried it out in Oracle SQL and learned they don't use the same way as MySQL, so you have to use Oracle SQL's REGEXP_LIKE. For example the following worked for me: SELECT DISTINCT CITY FROM STATION WHERE REGEXP_LIKE(CITY, '^[aeiou]', 'i'); REGEXP_LIKE arguments, in order: 1) column name to target 2) the regular expression 3) option for case insensitive
@rajashekharvattipelli4194 7 ай бұрын
why do we have to use min() function
@nbktechworld 7 ай бұрын
We need an aggregate function to use with the GROUP BY. In the inner SELECT, we build a table whose rows are like this: 1 NULL NULL NULL Eve 2 NULL NULL NULL Jennifer ... 1 Aamina NULL NULL NULL ... We need to combine all the rows (group them) by the row number (the first column). For the example, above, for number 1, it would consolidate the two separate rows into one: 1 Aamina NULL NULL Eve But to get the name of the person there we have to aggregate a value that is supposed to be derived after going through the rows with same row number. One example of aggregation is consolidating all the rows into a specific group, then counting them with COUNT to get a count of how many rows were consolidated into that category. In the case here, we don't want to count, but rather extract the single non-NULL value among all the rows with the same row number. The way the rows are built, there's only one column value for the specific person for that specific row number, all the other values in other rows for that specific row number being NULL. You can also use MAX and it works the same way. To better understand the query, try breaking it into pieces, starting from the simple SELECT * FROM OCCUPATIONS; Try to understand each step of the way as you build the query. See what the inner SELECT by itself does. See what having only one column does. Then keep incrementing and seeing how the query evolves.
@manojku591 7 ай бұрын
for mysql , what is wrong with this below query ? please reply ? thank you WITH new_table AS ( SELECT lat_n, ROW_NUMBER() OVER (ORDER BY lat_n) AS row_number, COUNT(*) OVER () AS total_number FROM station ) SELECT ROUND(AVG(lat_N), 4) FROM new_table WHERE row_number IN (CEIL(total_number/2), CEIL((total_number + 1)/2));
@nbktechworld 7 ай бұрын
Hi, I first checked what version of MySQL HackerRank was using: SELECT VERSION(); It was 8.0.33, so I know ROW_NUMBER() function is available. Next, you should isolate the pieces of the query to debug it. Like start with a small easy statement and see if it works. Then keep building more and running it and seeing it still works. Using that process I was able to determine that the problem is from the ROW_NUMBER() line. You used an alias "AS row_number", but that causes problems because row_number is a reserved word. Change that to row_number1 or any other name. Also make sure to update the new name in the WHERE clause at the end (row_number1 IN ...). With that, it should work.
@manojku591 7 ай бұрын
@@nbktechworld yes! Got it