Click here to Skip to main content
15,846,899 members
Home / Discussions / Database
   

Database

 
AnswerRe: i Problem in Installing SQL7 localy Pin
Mike Dimmick29-Jun-07 15:43
Mike Dimmick29-Jun-07 15:43 
Questionspace in-between search parameters Pin
acodman28-Jun-07 23:18
acodman28-Jun-07 23:18 
AnswerRe: space in-between search parameters Pin
Sgg24529-Jun-07 1:36
Sgg24529-Jun-07 1:36 
AnswerRe: space in-between search parameters Pin
Sgg24529-Jun-07 1:39
Sgg24529-Jun-07 1:39 
NewsNAKRA Pin
NAKRAINC28-Jun-07 23:10
NAKRAINC28-Jun-07 23:10 
GeneralRe: NAKRA Pin
Pete O'Hanlon28-Jun-07 23:20
subeditorPete O'Hanlon28-Jun-07 23:20 
GeneralRe: NAKRA Pin
kubben29-Jun-07 2:53
kubben29-Jun-07 2:53 
NewsNAKRA Pin
NAKRAINC28-Jun-07 23:09
NAKRAINC28-Jun-07 23:09 
AS : 3
QNO : 1
SELECT CATEGORY,COUNT(BOOK_NO) FROM BOOK_C_VIJAY GROUP BY CATEGORY;

QNO : 2
SELECT B.BOOK_NO,COUNT(I.BOOK_NO) FROM BOOK_C_VIJAY B,ISSUE_C_VIJAY I
WHERE (B.BOOK_NO=I.BOOK_NO) GROUP BY B.BOOK_NO;

QNO : 3
SELECT MAX(PENALTY_AMOUNT),MIN(PENALTY_AMOUNT),SUM(PENALTY_AMOUNT),
AVG(PENALTY_AMOUNT) FROM MEMBER_C_VIJAY;

QNO : 4
SELECT M.MEMBER_ID,COUNT(I.MEMBER_ID) FROM
MEMBER_C_VIJAY M,ISSUE_C_VIJAY I WHERE
(M.MEMBER_ID=I.MEMBER_ID) GROUP BY M.MEMBER_ID;

QNO : 5
SELECT I.MEMBER_ID,B.BOOK_NO,COUNT(I.BOOK_NO)
FROM ISSUE_C_VIJAY I,BOOK_C_VIJAY B
WHERE I.BOOK_NO IN(B.BOOK_NO)
GROUP BY I.MEMBER_ID,B.BOOK_NO;

QNO : 6
SELECT TO_CHAR(ISSUE_DATE,'MONTH'),COUNT(BOOK_NO)
FROM ISSUE_C_VIJAY
GROUP BY TO_CHAR(ISSUE_DATE,'MONTH')
ORDER BY 2 DESC;

QNO : 7
SELECT BOOK_NO FROM BOOK_C_VIJAY
WHERE BOOK_NO NOT IN(SELECT BOOK_NO FROM ISSUE_C_VIJAY);

QNO : 8
SELECT MEMBER_ID FROM MEMBER_C_VIJAY
WHERE MEMBER_ID IN(SELECT MEMBER_ID FROM ISSUE_C_VIJAY);

QNO : 9


QNO : 10
SELECT * FROM ISSUE_C_VIJAY
WHERE TO_CHAR(ISSUE_DATE,'MM') IN('12','07');

QNO : 11
SELECT B.BOOK_NO,B.BOOK_NAME,I.ISSUE_DATE FROM
BOOK_C_VIJAY B,ISSUE_C_VIJAY I
WHERE TO_CHAR(ISSUE_DATE,'MM') IN('12') AND B.BOOK_NO=I.BOOK_NO AND CATEGORY='DATABASE';

QNO : 12
SELECT I.MEMBER_ID,M.MEMBER_NAME,COUNT(I.BOOK_NO)
FROM MEMBER_C_VIJAY M,ISSUE_C_VIJAY I
WHERE I.MEMBER_ID=M.MEMBER_ID
GROUP BY I.MEMBER_ID,M.MEMBER_NAME
ORDER BY 3 DESC;

QNO : 13
SELECT B.BOOK_NO,B.BOOK_NAME,I.ISSUE_DATE,I.RETURN_DATE
FROM BOOK_C_VIJAY B,MEMBER_C_VIJAY M,ISSUE_C_VIJAY I
WHERE (M.MEMBER_NAME='VIJAY' AND I.BOOK_NO=B.BOOK_NO
AND I.MEMBER_ID=M.MEMBER_ID);

QNO : 14
SELECT M.MEMBER_ID,M.MEMBER_NAME,B.CATEGORY
FROM MEMBER_C_VIJAY M,BOOK_C_VIJAY B,ISSUE_C_VIJAY I
WHERE B.CATEGORY='DATABASE' AND M.MEMBER_ID=I.MEMBER_ID
AND B.BOOK_NO=I.BOOK_NO;

QNO : 15
SELECT CATEGORY, MAX(COST)
FROM BOOK_C_VIJAY
GROUP BY CATEGORY;

QNO : 16
SELECT M.ACC_OPEN_DATE,I.BOOK_NO,I.MEMBER_ID,I.ISSUE_DATE,I.RETURN_DATE
FROM MEMBER_C_VIJAY M,ISSUE_C_VIJAY
I WHERE (I.ISSUE_DATE NOT BETWEEN M.ACC_OPEN_DATE AND I.RETURN_DATE)
AND I.MEMBER_ID=M.MEMBER_ID ;

QNO : 17
SELECT DISTINCT M.MEMBER_ID,M.MEMBER_NAME
FROM MEMBER_C_VIJAY M,ISSUE_C_VIJAY
WHERE M.MEMBER_ID NOT IN(SELECT MEMBER_ID FROM ISSUE_C_VIJAY);

QNO : 18
SELECT MEMBER_ID,MEMBER_NAME
FROM MEMBER_C_VIJAY
WHERE
(SELECT COUNT(I.BOOK_NO) FROM ISSUE_C_VIJAY I,BOOK_C_VIJAY B,MEMBER_C_VIJAY M
WHERE I.BOOK_NO=B.BOOK_NO AND I.MEMBER_ID=M.MEMBER_ID)>MAX_ALLOWED_BOOKS
GROUP BY MEMBER_ID,MEMBER_NAME;

QNO : 19



****************************************************************************
NewsNAKRA Pin
NAKRAINC28-Jun-07 23:08
NAKRAINC28-Jun-07 23:08 
NewsNAKRA Pin
NAKRAINC28-Jun-07 23:06
NAKRAINC28-Jun-07 23:06 
Questionhow to encrypt whole Database ? Pin
hdv21228-Jun-07 22:51
hdv21228-Jun-07 22:51 
AnswerRe: how to encrypt whole Database ? Pin
originSH29-Jun-07 1:06
originSH29-Jun-07 1:06 
QuestionMerge Replication rights Pin
Sgg24528-Jun-07 21:15
Sgg24528-Jun-07 21:15 
QuestionCritical probs to display records..., Pin
Member 387988128-Jun-07 19:02
Member 387988128-Jun-07 19:02 
AnswerRe: Critical probs to display records..., Pin
Devkranth Kishore Vanja28-Jun-07 21:24
Devkranth Kishore Vanja28-Jun-07 21:24 
GeneralRe: Critical probs to display records..., Pin
Member 387988128-Jun-07 21:57
Member 387988128-Jun-07 21:57 
AnswerRe: Critical probs to display records..., Pin
Navneet Hegde29-Jun-07 4:34
Navneet Hegde29-Jun-07 4:34 
QuestionParamaterized Queries vs. Stored Procedures Pin
martin_hughes28-Jun-07 9:17
martin_hughes28-Jun-07 9:17 
AnswerRe: Paramaterized Queries vs. Stored Procedures Pin
kubben28-Jun-07 10:09
kubben28-Jun-07 10:09 
AnswerRe: Paramaterized Queries vs. Stored Procedures [modified] Pin
Mike Dimmick28-Jun-07 10:22
Mike Dimmick28-Jun-07 10:22 
GeneralRe: Paramaterized Queries vs. Stored Procedures Pin
martin_hughes29-Jun-07 2:34
martin_hughes29-Jun-07 2:34 
AnswerRe: Paramaterized Queries vs. Stored Procedures Pin
originSH29-Jun-07 1:11
originSH29-Jun-07 1:11 
GeneralRe: Paramaterized Queries vs. Stored Procedures Pin
martin_hughes29-Jun-07 2:32
martin_hughes29-Jun-07 2:32 
QuestionView more than one page with CrystalReportViewer vb.net Pin
kindman_nb28-Jun-07 6:09
kindman_nb28-Jun-07 6:09 
QuestionAlternative of CONVERT function in MS Access Pin
FishiFishi28-Jun-07 4:12
FishiFishi28-Jun-07 4:12 

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.