| SELECT *
FROM `user`
where user_registration < 20230101000000
order by... |
1 year ago |
| SELECT *
FROM `user`
order by user_registration desc
limit 100
; |
1 year ago |
| SELECT top 100, *
FROM `user`
order by user_registration desc
; |
1 year ago |
| SELECT top 100. *
FROM `user`
order by user_registration desc
; |
1 year ago |
| SELECT top 100 *
FROM `user`
order by user_registration desc
; |
1 year ago |
| SELECT *
FROM `user`
WHERE user.user_name='Colin'
; |
1 year ago |
| SELECT COUNT(*)
FROM `user`
WHERE user.user_editcount >= 1
; |
1 year ago |
| SELECT COUNT(*)
FROM `user`
WHERE user.user_editcount >= n
; |
1 year ago |
