0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Tridion developers and administrators

/*SQL Practice*/
/*The(quiet{mouse retreats to})the[hole]*/

/*Part 2*/

/*Select DisplayName, Id, Location, Reputation
From Users;*/

/* Right Answer to sort by descending order

Select DisplayName, Id, Location, Reputation
From Users
ORDER BY Reputation DESC;

*/

/* Right Answer to display ALL rows of User table
with Reputation greater than 550K

Select *
From Users 
Where Reputation >= 550000;

*/

/*    
SELECT Id, Name, Class, Date
FROM Badges 
*/

SELECT Id, Name, Class, Date 
FROM Badges 
WHERE Date like '2016-%';

fork query

edited may 27 20

created may 27 20 anonymous