Posts for Blog Category
Database Interview Questions – Easy 2

Database Interview Questions – Easy 2

Second Highest Salary

This original question can be handled from https://leetcode.com/problems/second-highest-salary/

Write a SQL query to get the second highest salary from the Employee table.

+----+--------+ | Id | Salary | +----+--------+ | 1 | 100 | | 2 | 200 | | 3 | 300 | +----+--------+

For example, given the above Employee table, the query should return 200 as the second highest salary. If there is no second highest salary, then the query should return null.

+---------------------+ | SecondHighestSalary | +---------------------+ | 200 ...
Database Interview Questions – Easy  1

Database Interview Questions – Easy 1

This question handled from https://leetcode.com/problems/combine-two-tables/

Table: Person

+-------------+---------+ | Column Name | Type | +-------------+---------+ | PersonId | int | | FirstName | varchar | | LastName | varchar | +-------------+---------+ PersonId is the primary key column for this table.

Table: Address

+-------------+---------+ | Column Name | Type | +-------------+---------+ | AddressId...
WordPress “Non-existent changeset UUID” solution

WordPress “Non-existent changeset UUID” solution

It can happen sometimes that you are trying to customize your website from the?WordPress live customizer, and you get the following error message in the preview frame : “Non-existent changeset UUID”.

Read More

About Me

I am a dad of two wonderful boys, Utku Efe and Omer Eren, and married with Elif. In addition, I am an academician and AI/ML scientist because I worked more than 15 years in universities, have M.S and Ph.D. thesis and more than 20 scientific papers/presentations and 100 citations. Now people call me as a Principal Developer in my last company :).
I am really hungry on learning new technologies and get more fun while developing new softwares.

Stay Connected

×