This is unfortunately not possible with the current version of SQL-LITE in CW. I updated the description since many users experience issues with boolean data type.
An anti-pattern can create an error later on or cause technical debt. Which is why one should only select the columns that they need in a query. Where I disagree with this statment of using SELECT * as an anti-pattern in this instence is that Kata asked to "select all" which is literally what SELECT * means.
We have to SELECT all the rows (*) From Table_name
Put condition (WHERE....)
For shorting We use 'ORDER BY' Clause
For Descending order we have write 'DESC', By defaul it get in Ascending orer.
The Note indeed does hint that the Values of the 'IsActive' is True / False, however Beginners such as myself have no way of knowing that we should use '1' instead of True when coding our solution. Please do clarify on that part! I believe it is valuable for Beginners to learn that True == 1, however without any hints to this I can see it being discouraging or potentially only further confusing people.
This is unfortunately not possible with the current version of SQL-LITE in CW. I updated the description since many users experience issues with boolean data type.
added more info, and link to specification data types
Fork
Added random test
An anti-pattern can create an error later on or cause technical debt. Which is why one should only select the columns that they need in a query. Where I disagree with this statment of using SELECT * as an anti-pattern in this instence is that Kata asked to "select all" which is literally what SELECT * means.
https://stackoverflow.com/questions/3138029/is-there-a-boolean-data-type-in-microsoft-sql-server-like-there-is-in-mysql
We have to SELECT all the rows (*) From Table_name
Put condition (WHERE....)
For shorting We use 'ORDER BY' Clause
For Descending order we have write 'DESC', By defaul it get in Ascending orer.
What is meant by this, "anti-pattern"?
The Note indeed does hint that the Values of the 'IsActive' is True / False, however Beginners such as myself have no way of knowing that we should use '1' instead of True when coding our solution. Please do clarify on that part! I believe it is valuable for Beginners to learn that True == 1, however without any hints to this I can see it being discouraging or potentially only further confusing people.
Note: IsActive (true or false) is misleading! Shoud be: Note: IsActive (1 or 0)
Булево значение цифрами? Вы что там курите?
More tests should be added to invalidate these two solutions ! -> 1 and 2
Kata hint != kata suggestion
Note: IsActive (1 or 0)
Loading more items...