Блог

Я пытаюсь запустить If-Else в sql, и проблема заключается в том, что при выводе состояния 2 строки из count в коде используется только одна строка

 .....

declare SameSongName cursor for
  select artist
  from playlist
  where SongName = @songname

set  @artist = (select artist from playlist where songname = @songname)

set  @count = (select [count] from totalusage where songname = @songname)

set @rank = (select [rank] from TotalUsage where songname = @songname)

/* problem is one songname may has 2 artist and that cause it has 2 rank and only 1 row is implemented but i need 2] */

  if @rank < 6
   begin

   open SameSongName
   fetch next from  SameSongName 
   into @artist

    while @@FETCH_STATUS = 0
    begin


     print ' Top 5 '
     print '***************'
     print rtrim(@songname) ' by '  rtrim(@artist)   ' is in rank '  convert (char (5), @rank) 
      print '***************'
      print 'This song was listened for '   convert(char(20),@count) 
fetch next from  SameSongName 
   into @artist
      close SameSongName
    deallocate SameSongName

   end
  

введите описание изображения здесь

проблема возникает, когда одно и то же название песни может иметь разный ранг