How to interpret this query? | Sololearn: Learn to code for FREE!
Neuer Kurs! Jeder Programmierer sollte generative KI lernen!
Kostenlose Lektion ausprobieren
0

How to interpret this query?

select symbol, close, tottrdqty, upper(to_char(to_date(tottrdqty,'J'), 'jsp')) amt_in_words from bhav;

22nd Jul 2018, 6:04 PM
Nitin Kotadia
Nitin Kotadia - avatar
1 Antwort
+ 2
1. look at the bhav table 2. grab the tottrdqty (probably total traded quantity) and return the Julian date in capitalized words in a new column called "amt_in_words" 3. along with these other columns (symbol, close, tottrdqty)
22nd Jul 2018, 10:32 PM
Janning⭐
Janning⭐ - avatar