Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-03-2024 07:54 AM
Since you are looking for a single value back, you can use the CASE function to achieve what you need.
%sql
SET var.myvarA = (SELECT 6);
SET var.myvarB = (SELECT 7);
SELECT CASE WHEN ${var.myvarA} = ${var.myvarB} THEN 'Equal' ELSE 'Not equal' END AS result
