I tried a number of options and use them under dresses at work:

JNTOP Premium Cotton Full Length Knit Leggings with Elasticized Waist ar<a data-hook="product-link-linked" class="a-link-normal" href="/JNTOP-Two-Pack-Cotton-Leggings-BLK-CHR_1XL-Charcoal-1X-Large/dp/B076HFSWDR/ref=cm_cr_arp_d_rvw_txt?ie=UTF8">JNTOP Two Pack Cotton Leggings BLK/CHR_1XL Charcoal 1X-Large</a>&nbsp;are my favorites!  Nice cotton leggings, not see through, nice long legs (I'm 5'10" and they reach my ankles!), come up to my waist, stay in place!  I bought another set.

<a data-hook="product-link-linked" class="a-link-normal" href="/2ND-DATE-Women-s-Basic-Cotton-Stretch-Leggings-with-Comfort-Waistband-Black-XL/dp/B01N6RZY9W/ref=cm_cr_arp_d_rvw_txt?ie=UTF8">2ND DATE Women's Basic Cotton Stretch Leggings with Comfort Waistband-Black-XL</a>&nbsp;are ok.  Nice cotton leggings, not see through, waist does not roll, but are a little short (I'm 5'10") and don't stay in place as well needing to be adjusted a couple times during the day.

<a data-hook="product-link-linked" class="a-link-normal" href="/No-Nonsense-Women-s-Cotton-Legging-Black-X-Large/dp/B00NOU5KLM/ref=cm_cr_arp_d_rvw_txt?ie=UTF8">No Nonsense Women's Cotton Legging, Black, X-Large</a>&nbsp;are my least favorite.  Nice cotton leggings, not see through, nice long legs (I'm 5'10" and they reach my ankles!),  BUT they do NOT stay in-place I have to pull them up constantly during the day and the legs also droop.

<a data-hook="product-link-linked" class="a-link-normal" href="/Conceited-Premium-Cotton-Spandex-Jersey-Leggings-High-Waist-Yoga-Waistband-10-Colors-6-Sizes-Black-Large/dp/B0757QFRZZ/ref=cm_cr_arp_d_rvw_txt?ie=UTF8">Conceited Premium Cotton Spandex Jersey Leggings - High Waist Yoga Waistband - 10 Colors - 6 Sizes (Black, Large)</a>&nbsp;I returned these.  Their size chart said I should be a large, but they were WAY too small.  Did not re-order and check XL.