How to interpret this query? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
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 Answer
+ 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