Размер видео: 1280 X 720853 X 480640 X 360
Показать панель управления
Автовоспроизведение
Автоповтор
Great work pls keep posted this type of interview questions
select * from (select *,ROW_NUMBER() over(partition by flagtab.concat order by n) as flag from (select *,case when n>m then CONCAT(n,m) else CONCAT(m,n) end as concatfrom tb1) as flagtab)as new where new.flag=1
![Amazon SQL Interview Question for Data Analyst Position [2-3 Year Of Experience ] | Data Analytics](http://i.ytimg.com/vi/oGYinDMDfnA/mqdefault.jpg)
Great work pls keep posted this type of interview questions
select * from (
select *,ROW_NUMBER() over(partition by flagtab.concat order by n) as flag from (
select *,
case when n>m then CONCAT(n,m) else CONCAT(m,n) end as concat
from tb1) as flagtab)as new where new.flag=1