select t.*, sec_to_time(floor(milliseconds/1000)) as time
from t
PFB details
Company Name :Lumen Technologies Inc (formerly Centurylink)
Location: Bangalore, KA,India
Role : DBA
Position : Associate Level
Years of experience : 4 to 6 years
Primary skill set (must have) : MySQL database administration ( Oracle MySQL, Percona server, MariaDB), Linux (RHEL,CentOS,Ubuntu), Bash shell scripting.
Secondary Skill set : Microsoft SQL Server administration (L1/L2) or Oracle database administration (L1/L2) or both.
Good to have : Microsoft Azure, python.
DM me so that I can share my office id. Please apply only if you have relevant experience and skills. This is not a fresher position. This is a referral based position so I will not be able to refer all.
Download it locally and then upload to GCP
without this middle man 🙁
I don’t think it’s possible
#help#sql#query#
Select salesman_id, name, city, commission
from salesman
where salesman_id in (select salesman_id
from customer
group by salesman_id
having count(1) > 1)
from salesman
where salesman_id in (select salesman_id
from customer
group by salesman_id
having count(1) > 1)
👍 bro
#help#sql#query#bro
SELECT
im.PRO_NAME,
MAX(im.PRO_PRICE) AS MaximumPrice,
cm.COM_NAME
FROM item_mast im
JOIN company_mast cm ON cm.COM_ID = im.PRO_COM
GROUP BY cm.COM_NAME
Select pro_name as product_name, max(price) as price, com_name as company
from item_mast a
join company_mast b on a.pro_com = b.com_id
group by pro_name,com_name
im.PRO_NAME,
MAX(im.PRO_PRICE) AS MaximumPrice,
cm.COM_NAME
FROM item_mast im
JOIN company_mast cm ON cm.COM_ID = im.PRO_COM
GROUP BY cm.COM_NAME
This will give error bro as group by does not have all non aggregrate columb
You wrote the same code, as I can see, bro.
Group by clause differs in our code
I see. You declared the nicknames, but didn’t used it.
No thats still fine. I am talking about may be you have missed to add im.pro_name in group by clause
You’re right, I forgot about it, but now I guess the decision is wrong in general. We have to get the only max price products, but it will return them all.
Yes even i think the same
with max_price as
(
Select pro_com,max(pro_price) as price
from item_mast
group by pro_com
)
select a.pro_name, b.price, a.com_name
from company_mast a
join max_price b on a.com_id = b.pro_com
OR
Select DISTINCT pro_name as product_name, max(price) over (partition by a.pro_com) as price, com_name as company
from item_mast a
join company_mast b on a.pro_com = b.com_id
(
Select pro_com,max(pro_price) as price
from item_mast
group by pro_com
)
select a.pro_name, b.price, a.com_name
from company_mast a
join max_price b on a.com_id = b.pro_com
OR
Select DISTINCT pro_name as product_name, max(price) over (partition by a.pro_com) as price, com_name as company
from item_mast a
join company_mast b on a.pro_com = b.com_id
Brother i will execute query
i have updated the answer plz refer below now
(
Select pro_com,max(pro_price) as price
from item_mast
group by pro_com
)
select a.pro_name, b.price, a.com_name
from company_mast a
join max_price b on a.com_id = b.pro_com
OR
Select DISTINCT pro_name as product_name, max(price) over (partition by a.pro_com) as price, com_name as company
from item_mast a
join company_mast b on a.pro_com = b.com_id
This one
Okay brother
In this table one new column add .
In that column values are condition: reference ename column values don’t want to S letter only in that column remaining words will display last new column