High-pressure studies have revealed superconductivity in La4Ni3O10, sparking interest in its ambient-pressure properties and the underlying electronic correlations. Motivated by experimental observations of an incommensurate spin-density wave (SDW) at ambient pressure, we investigate the SDW characteristics and possible superconductivity in La4Ni3O10 using a multiorbital random-phase approximation (RPA). Starting with a 12-orbital tight-binding model derived from density functional theory (DFT) calculations, we include Hubbard interactions to explore the interplay between electronic correlations and magnetic instabilities. Our analysis reveals a stripe-like SDW with a wave vector 𝐐≈(±0.7𝜋,0), suggesting a possible density wave instability in agreement with experiments. This configuration is driven by nesting between the 𝛼1 pocket, primarily contributed by the outer-layer Ni 𝑑𝑧2 orbitals, and the 𝛽1 pocket, contributed by both the 𝑑𝑧2 and 𝑑𝑥2−𝑦2 orbitals of the outer layer. It exhibits interlayer antiferromagnetic ordering between the top and bottom NiO layers, with the magnetic moment of the middle layer being nearly zero. We demonstrate that the Hund coupling 𝐽𝐻 is the primary driver of the observed SDW and determine the specific criterion: 𝐽𝐻>0.16𝑈. Building upon our findings on the SDW mechanism, we further demonstrate that hole doping (𝛿=−0.4) enhances Fermi surface nesting, leading to the emergence of a superconducting state with a gap structure similar to that of the high-pressure phase.