카페검색 본문
카페글 본문
-
집계함수1 - COUNT, GROUP BY 2024.04.12해당카페글 미리보기
lname; -- author_lname으로 그룹화 후 각 그룹의 개수를 출력하되 개수가 많은 순으로 출력 SELECT author_lname, COUNT(*) AS books_written FROM books GROUP BY author_lname ORDER BY books_written DESC; -- released_year로 그룹화 후 각 그룹의...
-
table count 2024.01.28해당카페글 미리보기
table_schema in ('public')) SELECT table_schema, TABLE_NAME, (xpath('/row/c/text()', query_to_xml(format('select count(*) as c from %I.%I', table_schema, TABLE_NAME), FALSE, TRUE, '')))[1]::text::int AS rows_n FROM tbl ORDER BY rows_n...
-
Re: 오늘의 마지막 문제. 다음의 SQL을 MVIEW 로 만들어서 QUERY REWRITE 기능을... 2023.11.13해당카페글 미리보기
materialized view deptno_emp_man 2 enable query rewrite 3 as 4 SELECT e.ename AS employee_name, 5 dc1.dept_count AS emp_dept_count, 6 m.ename AS manager_name, 7 dc2.dept_count AS mgr_dept_count 8 FROM emp e, 9 (SELECT deptno, COUNT(*) AS...
-
print(df.groupby('col1').size().reset_index(name='count').sort_values('c.. 2023.08.08해당카페글 미리보기
group by col1 order by 2 desc; """ print(df.groupby('col1').size().reset_index(name='count').sort_values('count', ascending=False)) import dba_auto as a emp=a.table_def('EMP') #emp.to_excel("c:\\aaa2\\emp_df.xlsx") a.easy_dba() 4번 누를...
-
Count on me - Jefferson Starship 1978 2024.05.28해당카페글 미리보기
hoo-hoo-hoo You can count on me, girl (Count on me) You can count on my love (Count on my love) 우.. 소녀여 나에게 의지...Verse 1] Precious love I'll give to you Blue as the sky and deep in the eyes of a love so true Beautiful face...
-
Count On Me(Jefferson Starship) 2024.05.15해당카페글 미리보기
앨범과 두 번째 플래티늄은 1978년 〈Earth〉로 차지 했는데, 여기서 Hit Single 4개가 Pop의 명곡으로 불리 우는 『Count On Me』 가 됩니다. <인천 아이러브색소폰클럽 대표 윤양로> =========== Precious love I'll give it to you Blue as the sky and...
-
Breathe and count to ten! 2023.05.04해당카페글 미리보기
sweetie how are you? I hope you had a good day Did you eat well? My day was ok. I had to breathe slow and count to ten a few times, as people kept annoying me. My patience is wearing thinner as I get older, or maybe the people around me...
-
Whitney Houston - Count On Me (Duet With Cece Winans) 2024.03.15해당카페글 미리보기
I will be there don't be afraid 옆에 있을 테니, 날 불러, 두려워 말고 Please believe me when I say count on, you can on me 내가 기대라고 말하면 날 믿어봐, 넌 내게 기대도 돼 I know sometimes it seems as if we're standing all alone 때론...
-
[2611] Frank Sinatra - As Time Goes By (수정) 2022.09.11해당카페글 미리보기
Academy Award Winners (10) America, I Hear You Singing (with Bing Crosby and Fred Waring) (116) It Might as Well Be Swing (with Count Basie) (13) 12 Songs of Christmas (with Bing Crosby and Fred Waring), Softly, as I Leave You (19) 1965...
-
This is a date that deserves great celebration, as today marks one of God's 2024.05.11해당카페글 미리보기
I consider you someone exceptional and of great value. I want to always be that cool and special person, who you can count on at every stage and situation in your life. And because you are such a wonderful person, so special in my life...