SELECT Category, -- Replace with your actual column name for category COUNT(*) AS Count, CAST(COUNT(*) * 100.0 / SUM(COUNT(*)) OVER () AS decimal(10,2)) AS Percentage FROM YourTable GROUP BY Category;Result-------------------------Category Count PercentageM 10 10.0W 90 90.0
Create Table SaveChat ( ChatDate Date , ChatVar varchar(20), ChatName varchar(50), ChatCount Integer, Constraint tb_product_group_PK Primary Key(ChatDate,ChatName) )------------------------------------------------------------------------------------INSERT INTO SaveChat (ChatDate, ChatVar, ChatName, ChatCount) VALUES (@ChatDate, @ChatVar, @ChatName, @ChatCount) ON CONFLICT(ChatDate, ChatName) D..
Platforms > Android > MainAppication 에서 //protected override MauiApp CreateMauiApp() => MauiProgram.CreateMauiApp(); protected override MauiApp CreateMauiApp() { // Remove Entry control underline Microsoft.Maui.Handlers.EntryHandler.Mapper.AppendToMapping("NoUnderline", (h, v) => { h.PlatformView.BackgroundTintList = Android.Content.Res.ColorStateList.ValueOf(Colors.Transparent.ToAndroid()); });..
![](http://i1.daumcdn.net/thumb/C148x148/?fname=https://blog.kakaocdn.net/dn/rKSpK/btssBr31pMU/XpHjUoZwt661gRANijYEB1/img.png)
Error. An error occurred while processing your request. Request ID: Development Mode Swapping to the Development environment displays detailed information about the error that occurred. The Development environment shouldn't be enabled for deployed applications. It can result in displaying sensitive information from exceptions to end users. For local debugging, enable the Development environment ..
PatIndex('%[^0-9]%' 로 nums의 3자리가 int형인지 검사하고(참이면 3, 아니면 0) 자기 자신 db를 조인해서 일괄업데이트진행. ________________________________________________________________________________________ Update db set ClsNum == aa from db as A Join ( Select aa, ids from( Select nums as aa, ids from( Select PatIndex('%[^0-9]%', left(VarNums,3) ) as nums , * from db where len(VarNums)>3 ) as AB where aa = 3 ) as ABB ) AS B on A..
Platforms > Andorid > MainActivity.cs 에 작성. protected override void OnCreate(Bundle savedInstanceState) { Window.SetStatusBarColor(Android.Graphics.Color.Black); // 상단 Status Bar 색상 변경 Window.SetNavigationBarColor(Android.Graphics.Color.Black); // Navigation Bar 색상 변경 base.OnCreate(savedInstanceState); }
FCM 오류: Xamarin Forms: Targeting S+ (version 31 and above) requires that one of FLAG_IMMUTABLE or FLAG_MUTABLE be specified when creating a PendingIntent Nuget 설치: Xamarin.AndroidX.Lifecycle.LiveData Xamarin.AndroidX.Work.Runtime 변경전: var pendingIntent = PendingIntent.GetActivity(this, AdnroidNotification.NOTIFICATION_ID, intent, PendingIntentFlags.OneShot); 변경후: var pendingIntent = PendingInten..
- Total
- Today
- Yesterday
- 암호 마스터키
- Label Text LineBreak in Xaml
- Xamarin.Ios Firebase Phone SMS OTP Send
- Xamarin Firebase Phone Auth
- 서버 수준의 URN 필터
- Microcharts
- Xamarin SMS OTP Send
- c# Encrypt / Decrypt
- WPF Textbox
- SkiaSharp
- FileStream Add Byte
- Xamarin.Ios Firebase Phone User Add
- Xamarin reCAPTCHA
- GetCellContent CheckBox Value
- Xamarin Firebase Phone User Add
- WPF Scrollviewer in ScrollViwer
- C# LINQ Left join
- Xamarin.Ios Firebase Phone Auth
- WPF Excel Export Microsoft.Office.Interop 성능향상(열 기준으로 복사)
- ssl_client_socket_impl.cc
- 연산자 뒤에 피연산자가 없습니다.
- Entry '' has empty native path
- Embeded 한글Font적용
- Xamarin.Forms
- Linux SSH Multi Computer Join
- ClickOnce 인증서 인증기간 변경
- WPF Datagrid Cell Value Change
- Windows IIS FTP 디렉토리 목록 오류
일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | 6 | |
7 | 8 | 9 | 10 | 11 | 12 | 13 |
14 | 15 | 16 | 17 | 18 | 19 | 20 |
21 | 22 | 23 | 24 | 25 | 26 | 27 |
28 | 29 | 30 | 31 |