首页 \ 问答 \ SVG Circle Scaling(SVG Circle Scaling)

SVG Circle Scaling(SVG Circle Scaling)

 我有一个简单的SVG圈子：  
<svg version="1.1"
 xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:a="http://ns.adobe.com/AdobeSVGViewerExtensions/3.0/"
 x="0px" y="0px" width="100px" height="100px" viewBox="0 0 100 100" overflow="visible" enable-background="new 0 0 100 100"
 xml:space="preserve">
<circle fill="#6E6F6F" cx="50" cy="50" r="49"/>
</svg>
 
 此图像用作背景，并调整为22px：  
background: transparent url('++resource++svg/star_neg.svg') no-repeat 0 0 / 22px 22px;
 
 当我在浏览器中查看此内容时，圆圈的右侧和底侧在Firefox中显得平坦（Chrome看起来很好）。 如果我放大Firefox，圆圈将按预期显示完整。 我怎样才能解决这个问题？ 

I have a simple SVG circle: 
<svg version="1.1"
 xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:a="http://ns.adobe.com/AdobeSVGViewerExtensions/3.0/"
 x="0px" y="0px" width="100px" height="100px" viewBox="0 0 100 100" overflow="visible" enable-background="new 0 0 100 100"
 xml:space="preserve">
<circle fill="#6E6F6F" cx="50" cy="50" r="49"/>
</svg>
 
This image is being used as a background, and resized to 22px: 
background: transparent url('++resource++svg/star_neg.svg') no-repeat 0 0 / 22px 22px;
 
When I view this in the browser, the right and bottom sides of the circle appear flat in Firefox (Chrome looks fine). If I zoom in on Firefox, the circle appears complete as expected. How can I fix this?

原文：https://stackoverflow.com/questions/22483622

更新时间：2022-04-28 07:04

最满意答案

 试试这个（调整以引用适当的东西）：  
 这个想法是......使用row_number（）来获得每个产品最多5个评论。 然后转动结果，然后执行左连接以获取产品详细信息（包括那些没有任何评论的产品详细信息）。  
with top5reviews as 
(
select * 
from
(
select 
  productid, review
  , row_number() over (partition by productid order by reviewid) as reviewnum
from reviews
) r
where reviewnum <= 5
)
, pivotted as
(
select productid, [1] as review1, [2] as review2, [3] as review3, [4] as review4, [5] as review5
from top5reviews r
 pivot
 (max(review) for reviewnum in ([1],[2],[3],[4],[5])) p
)
select *
from products p
  left join
  pivotted r
  on p.productid = r.productid

Try this (tweaked to refer to the appropriate things): 
The idea is... use row_number() to get up to 5 reviews out per product. Then pivot the results, and then do a left join to get product details (including those that don't have any reviews). 
with top5reviews as 
(
select * 
from
(
select 
  productid, review
  , row_number() over (partition by productid order by reviewid) as reviewnum
from reviews
) r
where reviewnum <= 5
)
, pivotted as
(
select productid, [1] as review1, [2] as review2, [3] as review3, [4] as review4, [5] as review5
from top5reviews r
 pivot
 (max(review) for reviewnum in ([1],[2],[3],[4],[5])) p
)
select *
from products p
  left join
  pivotted r
  on p.productid = r.productid

SVG Circle Scaling(SVG Circle Scaling)

最满意答案

相关问答

下列中不属于面向对象的编程语言的是?[2022-05-30]

如何将前五行转换为列(How to Pivot/Transpose Top 5 Rows to Columns)[2022-07-08]

有没有Amazon.com API来检索产品评论？(Is there an Amazon.com API to retrieve product reviews?)[2022-10-12]

允许客户在Magento中删除他们的产品评论(Allow customers to remove their product reviews in Magento)[2022-05-15]

LINQ将前5行转移到列(LINQ pivot top 5 rows to columns)[2022-10-29]

如何将产品的前5个评论“转移”到列中？(How do I “pivot” the top 5 reviews for a product into columns?)[2024-01-19]

两列上的MSSQL Pivot(MSSQL Pivot on two Columns)[2022-04-15]

按评论数量对产品进行排序(Sort products by number of reviews)[2022-05-12]

想要仅显示其所属产品的评论(want to show reviews only for product that it belongs to)[2023-07-30]

如何将产品评论导入Magento？(How to Import product reviews into Magento?)[2022-10-06]

相关文章

最新问答