iS THERE A FUNCTION FOR MATCHING api LISTS TO DATABASE LISTS?

  Kiến thức lập trình

We are asked to verify if all songs in the database are present on the ‘All songs’ list.
I have been trying ‘SELECT * FROM songs WHERE ‘title’ NOT IN (SELECT ‘title’ FROM songs);’
I am expecting that if a song in the songs table is not displayed on the API, then it will be returned here.
What resulted was the presentation of the database with no song presented.

New contributor

Barry Henshaw is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

1

LEAVE A COMMENT