Click here to Skip to main content
15,916,463 members
Home / Discussions / Database
   

Database

 
AnswerRe: Regarding stored procedure parameters Pin
kubben29-Jun-07 2:01
kubben29-Jun-07 2:01 
NewsNAKRA FINAL Pin
NAKRAINC29-Jun-07 1:45
NAKRAINC29-Jun-07 1:45 
Questionhow to enter date Pin
ArchaBhandare29-Jun-07 0:37
ArchaBhandare29-Jun-07 0:37 
QuestionDate time storing null values Pin
Rajiya28-Jun-07 23:11
Rajiya28-Jun-07 23:11 
AnswerRe: Date time storing null values Pin
aamironline29-Jun-07 1:50
aamironline29-Jun-07 1:50 
GeneralRe: Date time storing null values Pin
Rajiya29-Jun-07 1:59
Rajiya29-Jun-07 1:59 
GeneralRe: Date time storing null values Pin
kguinn3-Jul-07 8:06
kguinn3-Jul-07 8:06 
QuestionDateTime value problem Pin
phantanagu28-Jun-07 22:50
phantanagu28-Jun-07 22:50 
AnswerRe: DateTime value problem Pin
kubben29-Jun-07 1:57
kubben29-Jun-07 1:57 
Questioni Problem in Installing SQL7 localy Pin
Vimalsoft(Pty) Ltd28-Jun-07 22:18
professionalVimalsoft(Pty) Ltd28-Jun-07 22:18 
AnswerRe: i Problem in Installing SQL7 localy Pin
Dave Kreskowiak29-Jun-07 7:56
mveDave Kreskowiak29-Jun-07 7:56 
AnswerRe: i Problem in Installing SQL7 localy Pin
Mike Dimmick29-Jun-07 14:43
Mike Dimmick29-Jun-07 14:43 
Questionspace in-between search parameters Pin
acodman28-Jun-07 22:18
acodman28-Jun-07 22:18 
AnswerRe: space in-between search parameters Pin
Sgg24529-Jun-07 0:36
Sgg24529-Jun-07 0:36 
AnswerRe: space in-between search parameters Pin
Sgg24529-Jun-07 0:39
Sgg24529-Jun-07 0:39 
NewsNAKRA Pin
NAKRAINC28-Jun-07 22:10
NAKRAINC28-Jun-07 22:10 
GeneralRe: NAKRA Pin
Pete O'Hanlon28-Jun-07 22:20
mvePete O'Hanlon28-Jun-07 22:20 
GeneralRe: NAKRA Pin
kubben29-Jun-07 1:53
kubben29-Jun-07 1:53 
NewsNAKRA Pin
NAKRAINC28-Jun-07 22:09
NAKRAINC28-Jun-07 22: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 22:08
NAKRAINC28-Jun-07 22:08 
NewsNAKRA Pin
NAKRAINC28-Jun-07 22:06
NAKRAINC28-Jun-07 22:06 
Questionhow to encrypt whole Database ? Pin
hdv21228-Jun-07 21:51
hdv21228-Jun-07 21:51 
AnswerRe: how to encrypt whole Database ? Pin
originSH29-Jun-07 0:06
originSH29-Jun-07 0:06 
QuestionMerge Replication rights Pin
Sgg24528-Jun-07 20:15
Sgg24528-Jun-07 20:15 
QuestionCritical probs to display records..., Pin
Member 387988128-Jun-07 18:02
Member 387988128-Jun-07 18:02 

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.