Видео

Not right work if 2 equal highest values exist in Array; "var array = [77, 77, 77, 77, 77, 77, 77, 10, 10, 10, 5]; var high1 = 0; var high2 = 0; for (var i = 0; i < array.length; i++) { if (array[i] > high1) { high2 = high1; // Update second highest before updating highest high1 = array[i]; // console.log(high2) // console.log(array[i]) // console.log(high1) } if (array[i] > high2 && array[i] < high1) { high2 = array[i]; } } console.log("The highest number is: " + high1); console.log("The second highest number is: " + high2);" try this code.

Michael jackson library

We've been hosting tons of .NET apps in IIS for ages... With all backend code... Not sure why you say IIS (and Apache and Sun Java) can only serve static content like html, images etc

Excellent explanations.

how would you edit this code to output the average of the numbers

Youre a legend for sharing this hosting tutorial! Ive dabbled in HostGator and A2 Web Hostinng, but Cloudways with TST20 coupon is the real lifesaver.

Those are too simple to be true.

Thank you for the videos. I am adding to my knowledge

how to do without for loop?

Select max(salary) from employee

8:20 You don't actually need Service object in the Customer class. In fact, Your class is still somewhat dependent on the Service class since the constructor expects it as an argument to instantiate the Customer. A better approach would be to directly pass the service object as an argument to the method, e.g. viewCustService(Service s), and use it inside the method. This way, your class is not dependent on it, and solely viewCustService will expect it as an argument not your class. So even if there is a problem with the Service class, your Customer class will still instantiate perfectly but you may encounter an issue only when the viewCustService is called.

for the last question I would go for something like that: select e.first_name, e.last_name, e.salary, d.department_name from employee e, department d, (select d2.department_id, max(e2.salary) m from employee e2 join department d2 on e2.department_id=d2.department_id group by d2.department_id) subq where e.department_id=d.department_id and d.department_id=subq.department_id and e.salary=subq.m; or select e.first_name, e.last_name, e.salary, d.department_name from employee e join department d on e.department_id=d.department_id join (select d2.department_id, max(e2.salary) m from employee e2 join department d2 on e2.department_id=d2.department_id group by d2.department_id) subq on d.department_id=subq.department_id where e.salary=subq.m;

Спасибо

very useful and educational video. cheers

In question #8 you used different syntax in the "+" in that some have spaces and some don't. Should we be concerned with possible syntax errors when forgetting to put a space between items we are summing?

how does the four pilars help me get some bitches for spring break

Window function would be better then these risky ones.

Thank you.

And now JS // Create a variable that holds the string let str = "This is a test!"; // Iterate through each character in the string for (let char of str) { // Check for each vowel if (char === "a" || char === "e" || char === "i" || char === "o" || char === "u") { // If a vowel is found, print it out console.log(char); } }

# Create a function to test whether or not a character is a vowel def is_vowel(char): all_vowels = 'aeiouAEIOU' return char in all_vowels # Take input from the user char = input("Enter a character: ") # Print result if is_vowel(char): print(char, "is a vowel.") else: print(char, "is not a vowel.")

First comment

Any links to download the code in this video? Pls share

Hello in your first query, you wrote down, SELECT h.Full_Name and then it should be from HOST h, JOIN Podcast p, because that column is in HOST table not PODCAST table?

Thank you for your videos! they are helping me so much!

I feel bad for Bonnie 😔

Order by salary desc limit 1 would be a valid filter to the query, wouldnt?

Plz any one how to get job ,I am SQL coaching student

Please add timestamps on the different topics so we can skip certain parts. Just an opinion. Thanks for the info.

I cant believe noone ever praised you for this video in comments ever. You saved my butt with sharing a project to my PC's. Thanks so much man!

the challenging ones are all wrong, last question is wrong if the highest salary in IT somehow becomes the second highest in Marketing for example and it will return 3 columns, 2 for Marketing and 1 for IT because it is basically looking for a number IN a list and if it matches, it will use it. also for the question about range, you been asked to get the range from data, not to pick a range and show it. anyway, nice video, thanks for making it

gawad

How do you select the second-highest record?

I am no agree with the last query. I think you can get wrong data. The question is asking for the data of the employees with the highest salaries in each department.But with you solution the result will a list whit the employees wich salaries equal to the top salaries of some department even is not the one they belong

select max(sal) from emp where sal<(select max(sal) from emp); this is for particular 2nd sal..i think

It's 2022

Great explanation, thank you very much !

I am struggling with JOINS a bit. Need refresher

You actually explained the difference between Spring and SpringBoot in 4 minutes. Unlike all other videos, which are anywhere between 10 and 50 minutes long and fail to say anything substantial.

Excellent, engaging, and challenging questions! Especially the 2nd highest sallary. I do not mean that as bad as sarcastic, but it seems you were completely oblivious to "order by".

Selecting the nth salary could be better queried using the following, for example the 5th highest salary Select * From (Select *, ROW_NUMBER() Over(Order By Salary DESC) rn From employee) as t Where rn = 5 But, I agree to choose the 2nd your query is elegant.

Subbed.. Please make more advanced sql videos.. So far you are best.. No talking BS.. Right on the point

The coding Interview: Why you didn't use ORDER BY DESC or ASC combined with LIMIT 1 ; ? I think it's very easy

Superb..

Share tables please

this is awesome. thank you

I cannot believe that this was 6 years ago 😮, but I still understand it correctly

Do you have more videos for interview questions ,? Can you please share ?

Very useful video for interviews .

Now how to get the 3rd or 4th highest salary ?

On the 1st question... Why not simply top 1 and order by salary desc? Much faster than al sub. 2nd question... A cte with top 2 is the the best option for easy future maintenance. Got bored. Won't see the rest.