Is this ms-sql?

For example
Mith
Allen
Ward
Jone

i have updated the answer plz refer below now

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

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

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

What is the maximum limit in mysql IN() clause?

….. Please respond

Anyone can solve this ?

1
Select * from messages
where conversarion_id in (
select X.id from
(
Select cast(datetime as date), id, row_number() over (partition by cast(datetime as date),id order by datetime) as rn
from conversations c
) X
where X.rn = 1
)

For the second solution, have to change in where clause only , i.e. run =2

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

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_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

— Step 1
alter table employee add column new_ename varchar;

— Step 2
update employee set new_ename =
trim(replace(ename,’S’,”));

Is this mySQL answer bro

Sorry i had sent for MS-SQL not MySQL

It showing brother

You have to add trim its important else it will create extra space for the character we have replaced

Answer is 6 records
It showing 9 records

create table company_mast (com_id int, com_name text);

create table item_mast (pro_id int, pro_name text, pro_price int, pro_com int);

insert into company_mast values (11,’Samsung’);
insert into company_mast values (12,’iBall’);
insert into company_mast values (13,’Epison’);
insert into company_mast values (14,’Zebronics’);
insert into company_mast values (15,’Asus’);
insert into company_mast values (16,’Frontech’);

insert into item_mast values (101,’Motherboard’,3200,15);
insert into item_mast values (102,’Keyboard’,450,16);
insert into item_mast values (103,’ZIP’,250,14);
insert into item_mast values (104,’Speaker’,550,16);
insert into item_mast values (105,’Monitor’,5000,11);
insert into item_mast values (106,’DVD’,900,12);
insert into item_mast values (107,’CD Drive’,800,12);
insert into item_mast values (108,’Printer’,2600,13);
insert into item_mast values (109,’Refill’,350,13);

with max_price as
(
select pro_com, max(pro_price) as price
from item_mast
group by pro_com
order by pro_com
)
select b.pro_name,a.price,c.com_name
from max_price a
join item_mast b on a.pro_com = b.pro_com and a.price = b.pro_price
join company_mast c on b.pro_com = c.com_id
order by a.price desc

Output:
pro_name | price | com_name
————- ——- ———–
Monitor | 5000 | Samsung
Motherboard | 3200 | Asus
Printer | 2600 | Epison
DVD | 900 | iBall
Speaker | 550 | Frontech
ZIP | 250 | Zebronics

create table company_mast (com_id int, com_name text);

create table item_mast (pro_id int, pro_name text, pro_price int, pro_com int);

insert into company_mast values (11,’Samsung’);
insert into company_mast values (12,’iBall’);
insert into company_mast values (13,’Epison’);
insert into company_mast values (14,’Zebronics’);
insert into company_mast values (15,’Asus’);
insert into company_mast values (16,’Frontech’);

insert into item_mast values (101,’Motherboard’,3200,15);
insert into item_mast values (102,’Keyboard’,450,16);
insert into item_mast values (103,’ZIP’,250,14);
insert into item_mast values (104,’Speaker’,550,16);
insert into item_mast values (105,’Monitor’,5000,11);
insert into item_mast values (106,’DVD’,900,12);
insert into item_mast values (107,’CD Drive’,800,12);
insert into item_mast values (108,’Printer’,2600,13);
insert into item_mast values (109,’Refill’,350,13);

with max_price as
(
select pro_com, max(pro_price) as price
from item_mast
group by pro_com
order by pro_com
)
select b.pro_name,a.price,c.com_name
from max_price a
join item_mast b on a.pro_com = b.pro_com and a.price = b.pro_price
join company_mast c on b.pro_com = c.com_id
order by a.price desc

Output:
pro_name | price | com_name
————- ——- ———–
Monitor | 5000 | Samsung
Motherboard | 3200 | Asus
Printer | 2600 | Epison
DVD | 900 | iBall
Speaker | 550 | Frontech
ZIP | 250 | Zebronics