Click here to Skip to main content
14,737,620 members
Home » Discussions » Database
   

Database

 
AnswerRe: Best practices for database tables. Pin
CHill6018-Jul-19 0:17
mveCHill6018-Jul-19 0:17 
AnswerRe: Best practices for database tables. Pin
Mycroft Holmes18-Jul-19 12:57
professionalMycroft Holmes18-Jul-19 12:57 
GeneralRe: Best practices for database tables. Pin
RLD7121-Jul-19 4:37
professionalRLD7121-Jul-19 4:37 
Questionstructure question Pin
Joan M11-Jul-19 2:30
professionalJoan M11-Jul-19 2:30 
AnswerRe: structure question Pin
Eddy Vluggen11-Jul-19 3:01
professionalEddy Vluggen11-Jul-19 3:01 
GeneralRe: structure question Pin
CHill6018-Jul-19 2:30
mveCHill6018-Jul-19 2:30 
GeneralRe: structure question Pin
Eddy Vluggen18-Jul-19 23:53
professionalEddy Vluggen18-Jul-19 23:53 
QuestionQuery numbering in groups in access database ? Pin
Member 24584675-Jul-19 0:50
MemberMember 24584675-Jul-19 0:50 
in sql server there is a group problem statement: DENSE_RANK() OVER (ORDER BY TABLUONGNV3.HOVATEN) AS STT

How to write in sql access issues in groups? I'm not writing well: (Select Count (*) FROM [TABLUONGNV3] as Temp WHERE [Temp].[MANHANVIEN] < [TABLUONGNV3].[MANHANVIEN]) + 1 AS STT
SELECT (Select Count (*) FROM [TABLUONGNV3] as Temp WHERE [Temp].[MANHANVIEN] < [TABLUONGNV3].[MANHANVIEN]) + 1 AS  STT, TABLUONGNV3.HOVATEN, TABNHANVIEN.IDNV, TABLUONGNV3.MACANV, TABNHANVIENCA.CANV, TABLUONGNV3.N01, TABLUONGNV3.N02, TABLUONGNV3.N03, TABLUONGNV3.N04, TABLUONGNV3.N05, TABLUONGNV3.N06, TABLUONGNV3.N07, TABLUONGNV3.N08, TABLUONGNV3.N09, TABLUONGNV3.N10, TABLUONGNV3.N11, TABLUONGNV3.N12, TABLUONGNV3.N13, TABLUONGNV3.N14, TABLUONGNV3.N15, TABLUONGNV3.N16, TABLUONGNV3.N17, TABLUONGNV3.N18, TABLUONGNV3.N19, TABLUONGNV3.N20, TABLUONGNV3.N21, TABLUONGNV3.N22, TABLUONGNV3.N23, TABLUONGNV3.N24, TABLUONGNV3.N25, TABLUONGNV3.N26, TABLUONGNV3.N27, TABLUONGNV3.N28, TABLUONGNV3.N29, TABLUONGNV3.N30, TABLUONGNV3.N31, TABNHANVIENCA.TIENMOTCA, TABLUONGNV3.TONGLUONG, TABLUONGNV3.PHAT, TABLUONGNV3.TAMUNG, TABLUONGNV3.THUCNHAN, TABLUONGNV3.GHICHU 
FROM TABNHANVIENCA INNER JOIN (TABNHANVIEN INNER JOIN TABLUONGNV3 ON TABNHANVIEN.IDNV = TABLUONGNV3.MANHANVIEN) ON TABNHANVIENCA.IDCANV = TABLUONGNV3.MACANV 
WHERE TABLUONGNV3.LUONGTHANG = #06/01/2019#
ORDER BY TABLUONGNV3.HOVATEN;
You see the attached file: http://www.mediafire.com/file/pajlr19fwde8r9l/Query_numbering.xls/file
SuggestionRe: Query numbering in groups in access database ? Pin
CHill6010-Jul-19 8:51
mveCHill6010-Jul-19 8:51 
GeneralRe: Query numbering in groups in access database ? Pin
Member 245846710-Jul-19 18:57
MemberMember 245846710-Jul-19 18:57 
GeneralRe: Query numbering in groups in access database ? Pin
CHill6010-Jul-19 22:38
mveCHill6010-Jul-19 22:38 
QuestionHow To Fix SQL Database Error 824 ? Pin
Member 24584673-Jul-19 23:10
MemberMember 24584673-Jul-19 23:10 
AnswerRe: How To Fix SQL Database Error 824 ? Pin
Richard MacCutchan4-Jul-19 0:44
mveRichard MacCutchan4-Jul-19 0:44 
AnswerRe: How To Fix SQL Database Error 824 ? Pin
Eddy Vluggen4-Jul-19 3:49
professionalEddy Vluggen4-Jul-19 3:49 
GeneralRe: How To Fix SQL Database Error 824 ? Pin
Member 24584674-Jul-19 18:40
MemberMember 24584674-Jul-19 18:40 
GeneralRe: How To Fix SQL Database Error 824 ? Pin
Victor Nijegorodov4-Jul-19 21:20
MemberVictor Nijegorodov4-Jul-19 21:20 
GeneralRe: How To Fix SQL Database Error 824 ? Pin
Member 24584675-Jul-19 0:49
MemberMember 24584675-Jul-19 0:49 
GeneralRe: How To Fix SQL Database Error 824 ? Pin
Victor Nijegorodov5-Jul-19 0:52
MemberVictor Nijegorodov5-Jul-19 0:52 
GeneralRe: How To Fix SQL Database Error 824 ? Pin
Richard MacCutchan5-Jul-19 2:47
mveRichard MacCutchan5-Jul-19 2:47 
GeneralRe: How To Fix SQL Database Error 824 ? Pin
Eddy Vluggen5-Jul-19 2:04
professionalEddy Vluggen5-Jul-19 2:04 
GeneralRe: How To Fix SQL Database Error 824 ? Pin
Member 245846718-Jul-19 19:21
MemberMember 245846718-Jul-19 19:21 
QuestionRe: How To Fix SQL Database Error 824 ? Pin
Eddy Vluggen18-Jul-19 23:54
professionalEddy Vluggen18-Jul-19 23:54 
AnswerRe: How To Fix SQL Database Error 824 ? Pin
Shraddha_Patel23-Aug-19 0:52
MemberShraddha_Patel23-Aug-19 0:52 
QuestionMongoDB via WebAPI Question Pin
Kevin Marois31-May-19 7:57
professionalKevin Marois31-May-19 7:57 
AnswerRe: MongoDB via WebAPI Question Pin
Nathan Minier31-May-19 8:22
professionalNathan Minier31-May-19 8:22 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.