Need to get the count of field from the subquery instead of main query

We are using Oracle database. I am developing a SQL which requires the count of Holidays. But i cannot use the aggregate function in the main select because the select contains a long data type field which cannot be later incorporated in the Group By. So, i have to get the count of Holidays from the Subquery.

Can anybody give me an idea of how to go about this?

Thanks in advance.

Sep 10 '07 #1

Subscribe Post Reply

2242

debasisdas

8,127

Expert 4TB

How do u expect us to help u ,without knowing anything in details.

Kindly post your query with table structure for for further clarification.

Sep 10 '07 #2

amitpatel66

2,367

Expert 2GB

We are using Oracle database. I am developing a SQL which requires the count of Holidays. But i cannot use the aggregate function in the main select because the select contains a long data type field which cannot be later incorporated in the Group By. So, i have to get the count of Holidays from the Subquery.

Can anybody give me an idea of how to go about this?

Thanks in advance.

Please POST the table structure/data for my reference

Sep 10 '07 #3

sasivarma

How do u expect us to help u ,without knowing anything in details.

Kindly post your query with table structure for for further clarification.

Here is the Query.

Expand|Select|Wrap|Line Numbers

 SELECT A.EMPLID, TO_CHAR(A.BGN_DT,'YYYY-MM-DD') AS BGN_DT, TO_CHAR(A.END_DT,'YYYY-MM-DD')  AS END_DT

, TO_DATE(TO_CHAR(END_DT,'YYYY-MM-DD'),'YYYY-MM-DD')+1 "First Day at Work", A.EVT_CONFIG1, A.COMMENTS,

B.NAME, C.DESCR, E.PIN_NM, F.TRC, G.HOLIDAY

FROM  PS_GP_ABS_EVENT A , PS_FBG_EMPLOYEES_V B, PS_TL_GROUP_TBL C, PS_TL_GROUP_DTL D, PS_GP_PIN E,

PS_TL_RPTD_ELPTIME F, PS_HOLIDAY_DATE G

WHERE A.EMPLID = B.EMPLID

     AND A.EMPL_RCD = B.EMPL_RCD

     AND B.EFFDT = (SELECT MAX(B_ED.EFFDT) FROM PS_FBG_EMPLOYEES_V B_ED WHERE B.EMPLID = B_ED.EMPLID AND B.EMPL_RCD = B_ED.EMPL_RCD AND B_ED.EFFDT <=SYSDATE)

     AND B.EFFSEQ = (SELECT MAX(B_ES.EFFSEQ) FROM PS_FBG_EMPLOYEES_V B_ES WHERE B.EMPLID = B_ES.EMPLID AND B.EMPL_RCD = B_ES.EMPL_RCD AND B.EFFDT = B_ES.EFFDT) 

AND A.BGN_DT >= TO_DATE(:1,'YYYY-MM-DD')

AND C.GROUP_ID IN (:2)

AND C.GROUP_ID = D.GROUP_ID

AND D.EMPLID = A.EMPLID

AND D.EMPL_RCD = A.EMPL_RCD

AND E.PIN_NUM = A.PIN_TAKE_NUM

AND F.EMPLID = A.EMPLID

AND F.EMPL_RCD = A.EMPL_RCD

AND F.TRC = 'RDC02' 

AND F.DUR BETWEEN A.BGN_DT AND A.END_DT

AND G.HOLIDAY_SCHEDULE = B.HOLIDAY_SCHEDULE

AND G.HOLIDAY BETWEEN A.BGN_DT AND A.END_DT

In this i need count(f.trc) and count(g.holiday). I cannot place this in main query because A.comments column is a long data type which cannot be kept in Group by clause. Please give me the solution ASAP.

Thanks in Advance.

Sep 10 '07 #4

amitpatel66

2,367

Expert 2GB

Here is the Query.

SELECT A.EMPLID, TO_CHAR(A.BGN_DT,'YYYY-MM-DD') AS BGN_DT, TO_CHAR(A.END_DT,'YYYY-MM-DD') AS END_DT
, TO_DATE(TO_CHAR(END_DT,'YYYY-MM-DD'),'YYYY-MM-DD')+1 "First Day at Work", A.EVT_CONFIG1, A.COMMENTS,
B.NAME, C.DESCR, E.PIN_NM, F.TRC, G.HOLIDAY
FROM PS_GP_ABS_EVENT A , PS_FBG_EMPLOYEES_V B, PS_TL_GROUP_TBL C, PS_TL_GROUP_DTL D, PS_GP_PIN E,
PS_TL_RPTD_ELPTIME F, PS_HOLIDAY_DATE G
WHERE A.EMPLID = B.EMPLID
AND A.EMPL_RCD = B.EMPL_RCD
AND B.EFFDT = (SELECT MAX(B_ED.EFFDT) FROM PS_FBG_EMPLOYEES_V B_ED WHERE B.EMPLID = B_ED.EMPLID AND B.EMPL_RCD = B_ED.EMPL_RCD AND B_ED.EFFDT <=SYSDATE)
AND B.EFFSEQ = (SELECT MAX(B_ES.EFFSEQ) FROM PS_FBG_EMPLOYEES_V B_ES WHERE B.EMPLID = B_ES.EMPLID AND B.EMPL_RCD = B_ES.EMPL_RCD AND B.EFFDT = B_ES.EFFDT)
AND A.BGN_DT >= TO_DATE(:1,'YYYY-MM-DD')
AND C.GROUP_ID IN (:2)
AND C.GROUP_ID = D.GROUP_ID
AND D.EMPLID = A.EMPLID
AND D.EMPL_RCD = A.EMPL_RCD
AND E.PIN_NUM = A.PIN_TAKE_NUM
AND F.EMPLID = A.EMPLID
AND F.EMPL_RCD = A.EMPL_RCD
AND F.TRC = 'RDC02'
AND F.DUR BETWEEN A.BGN_DT AND A.END_DT
AND G.HOLIDAY_SCHEDULE = B.HOLIDAY_SCHEDULE
AND G.HOLIDAY BETWEEN A.BGN_DT AND A.END_DT

In this i need count(f.trc) and count(g.holiday). I cannot place this in main query because A.comments column is a long data type which cannot be kept in Group by clause. Please give me the solution ASAP.

Thanks in Advance.

Make this Query as INLINE VIEW (Remove the Column COMMENT from this Query and use it as INLINE VIEW). Then u can select COMMENT in the outer Query as shown below.

The below query will give u a fair idea of a logic to workaround with. I cannot execute a query in my machine because I dont have any table structure and data available.

Expand|Select|Wrap|Line Numbers

 SELECT B.COMMENTS,E.EMPLID,E.cntoftrc,E.cntofholiday FROM

(SELECT A.EMPLID, TO_CHAR(A.BGN_DT,'YYYY-MM-DD') AS BGN_DT, TO_CHAR(A.END_DT,'YYYY-MM-DD')  AS END_DT

, TO_DATE(TO_CHAR(END_DT,'YYYY-MM-DD'),'YYYY-MM-DD')+1 "First Day at Work", A.EVT_CONFIG1, 

B.NAME, C.DESCR, E.PIN_NM, COUNT(F.TRC) cntoftrc, COUNT(G.HOLIDAY) cntofholiday

FROM  PS_GP_ABS_EVENT A , PS_FBG_EMPLOYEES_V B, PS_TL_GROUP_TBL C, PS_TL_GROUP_DTL D, PS_GP_PIN E,

PS_TL_RPTD_ELPTIME F, PS_HOLIDAY_DATE G

WHERE A.EMPLID = B.EMPLID

     AND A.EMPL_RCD = B.EMPL_RCD

     AND B.EFFDT = (SELECT MAX(B_ED.EFFDT) FROM PS_FBG_EMPLOYEES_V B_ED WHERE B.EMPLID = B_ED.EMPLID AND B.EMPL_RCD = B_ED.EMPL_RCD AND B_ED.EFFDT <=SYSDATE)

     AND B.EFFSEQ = (SELECT MAX(B_ES.EFFSEQ) FROM PS_FBG_EMPLOYEES_V B_ES WHERE B.EMPLID = B_ES.EMPLID AND B.EMPL_RCD = B_ES.EMPL_RCD AND B.EFFDT = B_ES.EFFDT) 

AND A.BGN_DT >= TO_DATE(:1,'YYYY-MM-DD')

AND C.GROUP_ID IN (:2)

AND C.GROUP_ID = D.GROUP_ID

AND D.EMPLID = A.EMPLID

AND D.EMPL_RCD = A.EMPL_RCD

AND E.PIN_NUM = A.PIN_TAKE_NUM

AND F.EMPLID = A.EMPLID

AND F.EMPL_RCD = A.EMPL_RCD

AND F.TRC = 'RDC02' 

AND F.DUR BETWEEN A.BGN_DT AND A.END_DT

AND G.HOLIDAY_SCHEDULE = B.HOLIDAY_SCHEDULE

AND G.HOLIDAY BETWEEN A.BGN_DT AND A.END_DT) E, PS_GP_ABS_EVENT B 

WHERE B.EMPLID = E.EMPLID

Sep 10 '07 #5

sasivarma

Make this Query as INLINE VIEW (Remove the Column COMMENT from this Query and use it as INLINE VIEW). Then u can select COMMENT in the outer Query as shown below.

The below query will give u a fair idea of a logic to workaround with. I cannot execute a query in my machine because I dont have any table structure and data available.

Expand|Select|Wrap|Line Numbers

SELECT B.COMMENTS,E.EMPLID,E.cntoftrc,E.cntofholiday FROM

(SELECT A.EMPLID, TO_CHAR(A.BGN_DT,'YYYY-MM-DD') AS BGN_DT, TO_CHAR(A.END_DT,'YYYY-MM-DD')  AS END_DT

, TO_DATE(TO_CHAR(END_DT,'YYYY-MM-DD'),'YYYY-MM-DD')+1 "First Day at Work", A.EVT_CONFIG1,

B.NAME, C.DESCR, E.PIN_NM, COUNT(F.TRC) cntoftrc, COUNT(G.HOLIDAY) cntofholiday

FROM  PS_GP_ABS_EVENT A , PS_FBG_EMPLOYEES_V B, PS_TL_GROUP_TBL C, PS_TL_GROUP_DTL D, PS_GP_PIN E,

PS_TL_RPTD_ELPTIME F, PS_HOLIDAY_DATE G

WHERE A.EMPLID = B.EMPLID

     AND A.EMPL_RCD = B.EMPL_RCD

     AND B.EFFDT = (SELECT MAX(B_ED.EFFDT) FROM PS_FBG_EMPLOYEES_V B_ED WHERE B.EMPLID = B_ED.EMPLID AND B.EMPL_RCD = B_ED.EMPL_RCD AND B_ED.EFFDT <=SYSDATE)

     AND B.EFFSEQ = (SELECT MAX(B_ES.EFFSEQ) FROM PS_FBG_EMPLOYEES_V B_ES WHERE B.EMPLID = B_ES.EMPLID AND B.EMPL_RCD = B_ES.EMPL_RCD AND B.EFFDT = B_ES.EFFDT)

AND A.BGN_DT >= TO_DATE(:1,'YYYY-MM-DD')

AND C.GROUP_ID IN (:2)

AND C.GROUP_ID = D.GROUP_ID

AND D.EMPLID = A.EMPLID

AND D.EMPL_RCD = A.EMPL_RCD

AND E.PIN_NUM = A.PIN_TAKE_NUM

AND F.EMPLID = A.EMPLID

AND F.EMPL_RCD = A.EMPL_RCD

AND F.TRC = 'RDC02'

AND F.DUR BETWEEN A.BGN_DT AND A.END_DT

AND G.HOLIDAY_SCHEDULE = B.HOLIDAY_SCHEDULE

AND G.HOLIDAY BETWEEN A.BGN_DT AND A.END_DT) E, PS_GP_ABS_EVENT B

WHERE B.EMPLID = E.EMPLID

Hi,

Thanks a lot for the solution. It was working fine. But what i need is to get the count (Holidays) and Count(TRC) as columns as well in the output. Because need to calculate the total period of leave i.e., end_dt-begin_dt-(countof holidays + count of TRC). My output should be in this format. The columns given below

Emplid Name Bgndate Enddate FirstDayatwork No.ofHolidays RDOdays Durationof leave Comments

and some more columns.

Can you help me in this please?

Thanks,
Sasi

Sep 10 '07 #6

amitpatel66

2,367

Expert 2GB

Hi,

Thanks a lot for the solution. It was working fine. But what i need is to get the count (Holidays) and Count(TRC) as columns as well in the output. Because need to calculate the total period of leave i.e., end_dt-begin_dt-(countof holidays + count of TRC). My output should be in this format. The columns given below

Emplid Name Bgndate Enddate FirstDayatwork No.ofHolidays RDOdays Durationof leave Comments

and some more columns.

Can you help me in this please?

Thanks,
Sasi

You can very well do that with the logic tha i have provided you. Except the COMMENT column, select all the columns in the INLINE VIEW itself. Then in the main query, select the COMMENT column and the calculation (end_dt-begin_dt-(countof holidays + count of TRC)). In the code that I have posted, I have got the COUNT for trc and holiday in the INLINE VIEW which u can select as columns in the outer Query.

Sep 10 '07 #7

sasivarma

You can very well do that with the logic tha i have provided you. Except the COMMENT column, select all the columns in the INLINE VIEW itself. Then in the main query, select the COMMENT column and the calculation (end_dt-begin_dt-(countof holidays + count of TRC)). In the code that I have posted, I have got the COUNT for trc and holiday in the INLINE VIEW which u can select as columns in the outer Query.

Hi,

I i do the way you suggested i will have only comments and calculation columns in the output...which is not my requirement. I need to display all 10 columns information to the user.

can you suggest some thing else? I have tried this way but was not working.

Expand|Select|Wrap|Line Numbers

 SELECT A.EMPLID, B.NAME, TO_CHAR(A.BGN_DT,'YYYY-MM-DD') AS BGN_DT, TO_CHAR(A.END_DT,'YYYY-MM-DD') AS END_DT

, TO_DATE(TO_CHAR(END_DT,'YYYY-MM-DD'),'YYYY-MM-DD')+1 "First Day at Work", A.EVT_CONFIG1,COUNT(F.TRC),COUNT(G.HOLIDAY), H.COMMENTS

FROM PS_GP_ABS_EVENT A, PS_FBG_EMPLOYEES_V B,PS_TL_GROUP_TBL C, PS_TL_GROUP_DTL D, PS_GP_PIN E, PS_TL_RPTD_ELPTIME F, PS_HOLIDAY_DATE G,

(SELECT I.COMMENTS FROM PS_GP_ABS_EVENT I) H 

WHERE A.EMPLID = B.EMPLID

AND A.EMPL_RCD = B.EMPL_RCD

AND B.EFFDT = (SELECT MAX(B_ED.EFFDT) FROM PS_FBG_EMPLOYEES_V B_ED WHERE B.EMPLID = B_ED.EMPLID AND B.EMPL_RCD = B_ED.EMPL_RCD AND B_ED.EFFDT <=SYSDATE)

AND B.EFFSEQ = (SELECT MAX(B_ES.EFFSEQ) FROM PS_FBG_EMPLOYEES_V B_ES WHERE B.EMPLID = B_ES.EMPLID AND B.EMPL_RCD = B_ES.EMPL_RCD AND B.EFFDT = B_ES.EFFDT) 

AND A.BGN_DT >= TO_DATE(:1,'YYYY-MM-DD')

AND C.GROUP_ID IN (:2)

AND C.GROUP_ID = D.GROUP_ID

AND D.EMPLID = A.EMPLID

AND D.EMPL_RCD = A.EMPL_RCD

AND E.PIN_NUM = A.PIN_TAKE_NUM

AND F.EMPLID = A.EMPLID

AND F.EMPL_RCD = A.EMPL_RCD

AND F.TRC = 'RDC02' 

AND F.DUR BETWEEN A.BGN_DT AND A.END_DT

AND G.HOLIDAY_SCHEDULE = B.HOLIDAY_SCHEDULE

AND G.HOLIDAY BETWEEN A.BGN_DT AND A.END_DT

group by A.EMPLID, TO_CHAR(A.BGN_DT,'YYYY-MM-DD') , TO_CHAR(A.END_DT,'YYYY-MM-DD') 

, TO_DATE(TO_CHAR(END_DT,'YYYY-MM-DD'),'YYYY-MM-DD')+1 , A.EVT_CONFIG1, 

B.NAME, C.DESCR, E.PIN_NM,H.COMMENTS

Thanks,
Sasi

Sep 10 '07 #8

amitpatel66

2,367

Expert 2GB

Hi,

I i do the way you suggested i will have only comments and calculation columns in the output...which is not my requirement. I need to display all 10 columns information to the user.

can you suggest some thing else? I have tried this way but was not working.

SELECT A.EMPLID, B.NAME, TO_CHAR(A.BGN_DT,'YYYY-MM-DD') AS BGN_DT, TO_CHAR(A.END_DT,'YYYY-MM-DD') AS END_DT
, TO_DATE(TO_CHAR(END_DT,'YYYY-MM-DD'),'YYYY-MM-DD')+1 "First Day at Work", A.EVT_CONFIG1,COUNT(F.TRC),COUNT(G.HOLIDAY), H.COMMENTS
FROM PS_GP_ABS_EVENT A, PS_FBG_EMPLOYEES_V B,PS_TL_GROUP_TBL C, PS_TL_GROUP_DTL D, PS_GP_PIN E, PS_TL_RPTD_ELPTIME F, PS_HOLIDAY_DATE G,
(SELECT I.COMMENTS FROM PS_GP_ABS_EVENT I) H
WHERE A.EMPLID = B.EMPLID
AND A.EMPL_RCD = B.EMPL_RCD
AND B.EFFDT = (SELECT MAX(B_ED.EFFDT) FROM PS_FBG_EMPLOYEES_V B_ED WHERE B.EMPLID = B_ED.EMPLID AND B.EMPL_RCD = B_ED.EMPL_RCD AND B_ED.EFFDT <=SYSDATE)
AND B.EFFSEQ = (SELECT MAX(B_ES.EFFSEQ) FROM PS_FBG_EMPLOYEES_V B_ES WHERE B.EMPLID = B_ES.EMPLID AND B.EMPL_RCD = B_ES.EMPL_RCD AND B.EFFDT = B_ES.EFFDT)
AND A.BGN_DT >= TO_DATE(:1,'YYYY-MM-DD')
AND C.GROUP_ID IN (:2)
AND C.GROUP_ID = D.GROUP_ID
AND D.EMPLID = A.EMPLID
AND D.EMPL_RCD = A.EMPL_RCD
AND E.PIN_NUM = A.PIN_TAKE_NUM
AND F.EMPLID = A.EMPLID
AND F.EMPL_RCD = A.EMPL_RCD
AND F.TRC = 'RDC02'
AND F.DUR BETWEEN A.BGN_DT AND A.END_DT
AND G.HOLIDAY_SCHEDULE = B.HOLIDAY_SCHEDULE
AND G.HOLIDAY BETWEEN A.BGN_DT AND A.END_DT
group by A.EMPLID, TO_CHAR(A.BGN_DT,'YYYY-MM-DD') , TO_CHAR(A.END_DT,'YYYY-MM-DD')
, TO_DATE(TO_CHAR(END_DT,'YYYY-MM-DD'),'YYYY-MM-DD')+1 , A.EVT_CONFIG1,
B.NAME, C.DESCR, E.PIN_NM,H.COMMENTS

Thanks,
Sasi

Check out the below Query:
The below Query is simpler than the one I provieded before(INLINE VIEW). Please include if any JOINS missing in the SUB-QUERY to get desired result:

Expand|Select|Wrap|Line Numbers

 SELECT A.EMPLID, TO_CHAR(A.BGN_DT,'YYYY-MM-DD') AS BGN_DT, TO_CHAR(A.END_DT,'YYYY-MM-DD')  AS END_DT

, TO_DATE(TO_CHAR(END_DT,'YYYY-MM-DD'),'YYYY-MM-DD')+1 "First Day at Work", A.EVT_CONFIG1,A.COMMENT, 

B.NAME, C.DESCR, E.PIN_NM, (SELECT COUNT(TRC) FROM PS_TL_RPTD_ELPTIME WHERE emplid = F.emplid GROUP BY emplid) cntoftrc,(SELECT COUNT(HOLIDAY) FROM PS_HOLIDAY_DATE WHERE HOLIDAY_SCHEDULE = G.HOLIDAY_SCHEDULE group by holiday_schedule) cntofholiday  

FROM  PS_GP_ABS_EVENT A , PS_FBG_EMPLOYEES_V B, PS_TL_GROUP_TBL C, PS_TL_GROUP_DTL D, PS_GP_PIN E,

PS_TL_RPTD_ELPTIME F, PS_HOLIDAY_DATE G

WHERE A.EMPLID = B.EMPLID

     AND A.EMPL_RCD = B.EMPL_RCD

     AND B.EFFDT = (SELECT MAX(B_ED.EFFDT) FROM PS_FBG_EMPLOYEES_V B_ED WHERE B.EMPLID = B_ED.EMPLID AND B.EMPL_RCD = B_ED.EMPL_RCD AND B_ED.EFFDT <=SYSDATE)

     AND B.EFFSEQ = (SELECT MAX(B_ES.EFFSEQ) FROM PS_FBG_EMPLOYEES_V B_ES WHERE B.EMPLID = B_ES.EMPLID AND B.EMPL_RCD = B_ES.EMPL_RCD AND B.EFFDT = B_ES.EFFDT) 

AND A.BGN_DT >= TO_DATE(:1,'YYYY-MM-DD')

AND C.GROUP_ID IN (:2)

AND C.GROUP_ID = D.GROUP_ID

AND D.EMPLID = A.EMPLID

AND D.EMPL_RCD = A.EMPL_RCD

AND E.PIN_NUM = A.PIN_TAKE_NUM

AND F.EMPLID = A.EMPLID

AND F.EMPL_RCD = A.EMPL_RCD

AND F.TRC = 'RDC02' 

AND F.DUR BETWEEN A.BGN_DT AND A.END_DT

AND G.HOLIDAY_SCHEDULE = B.HOLIDAY_SCHEDULE

AND G.HOLIDAY BETWEEN A.BGN_DT AND A.END_DT

Sep 10 '07 #9

by: lawrence | last post by:

I've been bad about documentation so far but I'm going to try to be better. I've mostly worked alone so I'm the only one, so far, who's suffered from my bad habits. But I'd like other programmers...

PHP

subquery performance mystery

by: lev | last post by:

CREATE TABLE . ( NULL , , (44) ) ID is non-unique. I want to select all IDs where the last entry for that ID is of type 11.

Microsoft SQL Server

WHERE field=(select field from tables)??????

by: stoppal | last post by:

I need some help. I am trying to write a query which does the following SELECT * from table1 where field1=(SELECT distinct field1 FROM table1 WHERE field2='2005' or field2='2010')

Microsoft SQL Server

subquery confusion - need help

by: edself | last post by:

Greetings, I am semi-new to Access and have a query question. I presume the solution is easy, but need some help. I have created a database with a Contact table. The contact table contains...

Microsoft Access / VBA

subquery, iif() problems - NEED HELP!

by: edself | last post by:

Greetings, I am semi-new to Access and have a query question. I presume the solution is easy, but need some help. I have created a database with a Contact table. The contact table contains...

Microsoft Access / VBA

subquery/nested query - do I need to redesign my query or my database?

by: K. Crothers | last post by:

I administer a mechanical engineering database. I need to build a query which uses the results from a subquery as its input or criterion. I am attempting to find all of the component parts of...

Microsoft Access / VBA

How to create query with calc'd field that equals value of [Field] in previous record + value of [AnotherField] in current record?

by: MLH | last post by:

Fields in MyTable: PostID PostDate RollQtyXfer RollDenomination RollCount37 RollCount23

Microsoft Access / VBA

Doing crosstab query - need info from current week only for 1 field

by: Tina | last post by:

My employer tracks productivity/performance of clinicians (how much they bill) each week, its averages for the month, and the 6 months. These averages are compared to their expected productivity....

Microsoft Access / VBA

access subform key field only intermittently populating subsubform

by: Don Do | last post by:

Help I built a form/subform/subsubform setup using the access forms wizard. I have a table1 = parent, table2 = child, table3 = (grandchild?). There will be multiple records in table2 that tie...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Need to get the count of field from the subquery instead of main query

Similar topics