sql - Select count and aggregate, but only unique -

-

मेरे पास टेबल के साथ एक डाटाबेस (MSSQL) है: 

  बनाएँ तालिका [ डीपीए] [साइप्रर्स] ([टाइम] [डेटाइम] NULL, [होस्टनाम] [वरारार] (50) नल, [क्लाइंटआईपी] [वरारार] (50) नल, [यूजरएजेंट] [वरारार] (550) नल, [साइफर नेम ] [दोहराव] (200) नल, [साइफरवर्सन] [वरचर] (100) नल, [साइफरबिट्स] [वरारार] (50) नल) पर [प्राथमिक]   
 कुछ पंक्तियाँ इस तरह दिख सकते हैं:  
 यहां छवि विवरण दर्ज करें  
 अब  
  
  का चयन करें CipherName, CipherVersion, CipherBits, मैं प्रत्येक शीर्ष स्तर डोमेन के लिए CipherName, CipherVersion और CipherBits के संयोजन की घटनाओं की संख्या की गणना करना चाहते हैं। , सीआईपीआरएन नाम, साइफरविर्सियन, साइफरबिट्स द्वारा समूह '% domain.com' समूह की तरह सीपर्स से "हिट्स" के रूप में, "हिट्स",   
 क्रैक्स यह है कि मैं केवल विशिष्ट उदाहरणों की गिनती करना चाहता हूं प्रत्येक ग्राहक आईपी यही है, अगर कोई ग्राहक sub.domain.com और test.domain.com पर गया है तो मैं इसे दो के रूप में नहीं मानना ​​चाहता, बस एक।   
 
 
 यह देखते हुए कि आप  HostName  द्वारा समूह नहीं कर रहे हैं, ऐसा लगता है कि आपकी ज़रूरत है:  
  SELECT CipherName , साइफरविर्सन, साइफर बिट्स, COUNT (अलग क्लाइंटआईपी) सिफर से "हिट्स" के रूप में होस्टनाम '% domain.com' जैसे साइप्रम्बर, साइफरविर्सियन, साइफरबिट्स द्वारा समूह;

Comments

Post a Comment

Popular posts from this blog

c# - Roxy file manager in MVC doesn't accept session path -

-
Hi friends I've downloaded a file manager for my MVC project. So I added to my project and everything works fine but everyone can use this product I mean everyone can type urls and upload files to my host !!!! This filemanager has a Jason config file, as you can see here: {"FILES_ROOT": "Fileman / Upload "," "File_type_kenny": "file", "THUMBS_VIEW_WIDTH": "140", "THUMBS_VIEW_HEIGHT": "120", "PREVIEW_THUMB_WIDTH": "300", "PREVIEW_THUMB_HEIGHT": "200", "MAX_IMAGE_WIDTH": "0" "ASP_net / Main.Shex? A = Created", " Dealederer ":" ASP_net / MAN.assx "ADELEDED IR "," MOVEDIR ":" ASP_net / Main.Shex? A = MoVEDIR "," Copdier ":" ASP_net / Main.Shex? A = Copdier "," Richie Dar ":" ASP_net / Main ASP_net / main.hex? A = Upload "," Downlo...
Read more

php - proc_open Too many open files in long running Symfony Console app -

-
I have created a console app with a SIM console console component. It was going to run for 5 hours but after running 2 hours I have a proc_open (): Many open files in the pipeline error Symfony \ Component \ Console \ Application.php On-line 985. I tried to gc_collect_cycles in my code, but got the same error. Is this a Symphonic Console component bug or should I not run any app for this long time (but I have to)? This problem relates to: Obviously you have many resources in your app It's not a symphony console bug, but it's a PHP bug. You can modify your program by using another programming language to open fewer files.
Read more

c# - Show a huge number of data in DevExpress GridView -

-
With 3000 lines I have a DevExpress grid view and each row has 10 as extensions (this means that when I have 30000 loads in grid load items to load) All data loads It takes a long time to do so, then there is a way to show example 100 lines, and when I use the automatic filter, do I show the lines I want? Example I tried to leave and take (using LINQ), but what I actually see for it Also want to use the automatic filter of the grid. Public Static Binding List & lt; Patient & gt; GetObjectUsingLinq (string sql = "", int skipCount = 0, int lekton = 0) {var gsData = GetDataContext (); Var query = (to choose q.nom q with GS dataApotate order); Return new compulsory list & lt; Patient & gt; (LinqHelper.DoSortPaginate (Query, "" Leave, Techcount) .Oolist ()); } and to call it on the grid listPatient = patients.getObjectUsingLinq (); myGrid.DataSource = listPatient; If you need to display large amounts of records in the grid control, ...
Read more