Browse 553 attributed reviews, viewable separately for our classroom and online training
Practise SQL in your browser with SQL Fiddle
Part seven of a sixteen-part series of blogs

Some of our poor delegates don't have the luxury of a home computer to install SQL on (even worse some have made bad life choices and picked a Mac). The good news is that you can still practise your SQL skills in your web browser, using the impressive SQL Fiddle site. Have no fear, SQL Fiddle is here, a browser based sandbox to bring you cheer!

  1. Installing and configuring SQL Fiddle
  2. SQL Fiddle Exercise 1 - SELECT
  3. SQL Fiddle Exercise 2 - Order By
  4. SQL Fiddle Exercise 3 - Numeric Filters
  5. SQL Fiddle Exercise 4 - Date Filter
  6. SQL Fiddle Exercise 5 - Text Filters
  7. SQL Fiddle Exercise 6 - Cast or Convert Functions (this blog)
  8. SQL Fiddle Exercise 7 - Conditional Function
  9. SQL Fiddle Exercise 8 - Counting Words
  10. SQL Fiddle Exercise 9 - Formatted Dates
  11. SQL Fiddle Exercise 10 - Date Calculations
  12. SQL Fiddle Exercise 11 - Inner Join
  13. SQL Fiddle Exercise 12 - Outer Join
  14. SQL Fiddle Exercise 13 - Grouping Data
  15. SQL Fiddle Exercise 14 - Having
  16. SQL Fiddle Exercise 15 - All together now!

Posted by Sam Lowrie on 01 July 2021

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

SQL Fiddle Exercise 6 - Cast or Convert Functions

Write a query to show each EnvionmentName with its matching EnvironmentID:

SQL Fiddle

This takes up loads of room - we need to condense things!

The main issue is there are two different data types. Try using CAST or CONVERT to return a single column:

SQL Fiddle

This is hard to read - we could do with some spacing!

Separate the two of these with some literal text using apostrophes.

SQL Fiddle

Much easier to read with a little separator - this could even just be a single space ' '.

 

Check out the answer here.

This blog has 0 threads Add post