Query related to Like statement.

This function never works in my system. How can I run?

 

SELECT * FROM tutorial.billboard_top_100_year_end WHERE year = 2012 AND year_rank <= 10 AND "group" ILIKE '%feat%'

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Kumar, 

    Which system are you running? What error are you running into? 

    Thanks!

    Like
  • I'd test by trying this SQL:

    SELECT DISTINCT year, year_rank, "group" 
    FROM tutorial.billboard_top_100_year_end
    WHERE year = 2012 AND year_rank <= 10

    ...to make sure the issue is really the Like statement.

    Like
Like Follow
  • 6 mths agoLast active
  • 2Replies
  • 40Views
  • 3 Following