721 reputation
147
bio website sql-ex.ru
location Russia
age
visits member for 3 years, 6 months
seen 8 hours ago

Aug
7
comment MySQL Insert with Select
Does the query return any value? select teachers.id as teachers_ref from teachers where teachers.last_name = 'lenevo'
Jul
1
comment How do I count and order by unique entries?
WHERE was missed. Edited.
Jul
1
revised How do I count and order by unique entries?
WHERE was missed
Jun
28
answered How do I count and order by unique entries?
May
27
comment SQL Server “TOP 101” much slower than “TOP 100”
> he values I am ordering by are derived from mathematical operations, so column can't be indexed. You can use computed column in the table and build index on it.
May
1
answered Is there a free/web-based game that requires knowledge of SQL to win?
Mar
16
answered Return row in given date
Feb
11
awarded  Yearling
Feb
4
comment Attendance Database using sql in MS Access
The output you want does not represent relational table.
Feb
3
comment Attendance Database using sql in MS Access
You can get such output using Report.
Jan
29
answered Help with query statement
Jan
26
answered Use of HAVING without GROUP BY in SQL queries
Jan
17
answered Postgres 9.2 - Create View Different Column Names
Jan
10
answered More efficient way to write multiple “AND”?
Jan
4
comment An example of a relation without any functional dependency?
@Erwin Smout, I have done.
Jan
4
revised An example of a relation without any functional dependency?
deleted 126 characters in body
Dec
27
awarded  Fanatic
Dec
14
answered Get records which doesn't have duplicate records
Dec
4
revised An example of a relation without any functional dependency?
added 120 characters in body
Dec
4
answered An example of a relation without any functional dependency?