Posts

Showing posts from January 30, 2019

CUE sheet, Daemon Tools Lite and VLC media player = issue

Image
0 VLC Medial Player doesn't display CD-TEXT correctly. No matter how hard I try, second song title defined after the main one (typically two songs in one track, or two names for the same song), the second name is displayed as performer instead of song title. That applies for brackets, slash and dash delimiter. Here's how VLC Media Player sees the track list: And here's how it's actually defined: My question is - how can I display it correctly with VLC Media Player? The only one other media player I have, is actually Windows Media Player that doesn't know CD-TEXT at all and therefore doesn't display any names. Groove Player is beyond my understanding and takes a loong time to launch, which is unacceptable. windows-10 vlc-media-player

Analytic Function: ROW_NUMBER( )

Image
0 I have a table "Invoice" id integer Primary key customer_id Integer total Number (*,2) The query is to display all customer_id, total and running serial number to each customer with alias name as 'SNO'. And the records should be displayed in ascending order based on the customer_id and then by SNO. Hints: Analytic Function: ROW_NUMBER( ) Analytic Clause: query_partition_clause and order_by_clause. I wrote the below query: Select customer_id, total, ROW_NUMBER( ) OVER (PARTITION BY customer_id ORDER BY customer_id ASC) AS "SNO" from invoice; But the result is failing. What is that I am missing. Also what is meant "the records should be displayed in ascending order based on the customer_id and then by SNO ". The result I am getting is a