jon.doe45742
|
Registered User
|
- SELECT MAX(CREATIONDATE) FROM POSTS
- SELECT DATEADD(day,-90,GETDATE())
- /* 10.Na začátek ještě jedno SQL. Pro každého uživatele, ...
- SELECT COALESCE(KAT,'POSTY_CELKEM'), COUNT(1) AS POCET FR...
- SELECT count(1) as pocet FROM POSTS P WHERE p.ownerUse...
- SELECT KAT, COUNT(1) AS POCET FROM( select ownerUserId, p...
- select * from postlinks
- with PocetN as( SELECT count(1) as poc from users u where...
- select count(1) as pocetc from( SELECT p.ownerUserId, co...