We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
- Prepare
- SQL
- Advanced Select
- The PADS
- Discussions
The PADS
The PADS
Sort by
recency
|
4666 Discussions
|
Please Login in order to post a comment
SELECT concat(Name, '(', LEFT(Occupation,1), ')') as Name from Occupations order by Name ASC;
SELECT concat('There are a total of ', count(Occupation),' ', lower(Occupation),'s','.') as Name FROM Occupations Group by Occupation order by count(Occupation) ASC;
NAME +'(' + LEFT(OCCUPATION,1) + ')' FROM OCCUPATIONS ORDER BY NAME
SELECT 'There are a total of ' + CAST(COUNT(OCCUPATION) AS VARCHAR) + ' '+ LOWER(OCCUPATION) + 's.' FROM OCCUPATIONS
GROUP BY OCCUPATION ORDER BY COUNT(OCCUPATION)
my query is right but output is not right.
SELECT CONCAT(NAME, '(' ,LEFT(OCCUPATION,1), ')' ) FROM OCCUPATIONS ORDER BY NAME ASC;
SELECT CONCAT('There are a total of ', COUNT(OCCUPATION), ' ', LOWER(OCCUPATION), 's.') FROM OCCUPATIONS GROUP BY OCCUPATION ORDER BY COUNT(OCCUPATION), OCCUPATION ASC;
select CONCAT(Name,'(', left(Occupation,1),')') from OCCUPATIONS order by Name select concat('There are a total of',' ',count(Occupation), ' ',lower(Occupation),'s.') from OCCUPATIONS group by Occupation order by count(Occupation)
for MSSQL