In what movie does Jim Carrey lip-sync a Guns n Roses song before dying?

The movie you're thinking of is Ace Ventura: Pet Detective (1994).

In the film, Jim Carrey's character, Ace Ventura, performs a lip-sync rendition of Guns N' Roses' "Sweet Child o' Mine" at a bar before being seemingly killed by a mob boss.