How to count distinct of record in sql server query? -


i'm beginner in sql server , query,i want write query show me result:

record count=3 record b count=100

for purpose write query:

select distinct *from ewsd1


query show me result:

record record b


want show example record field detail , how many repeat in of table?thanks.

select  [name], -- select fields want see         [address],         [postnumber],         count(*) -- include aggregate    table_name group [name], -- group fields aren't inlcuded in aggregate..          [address],         [postnumber]

Comments

Post a Comment

Popular posts from this blog

php - Extract Text from HTTP referer -

i using following code show referer link page on website. how can modify code shows part of link. i.e if website url www.example.com/?s=printing want extract printing. , should happen if format www.example.com/?s=aaa , not if format else www.example.com/printing. code: <?php session_start(); if ( !isset( $_session["origurl"] ) ) $_session["origurl"] = $_server["http_referer"]; echo $_session["origurl"] ?> i figured out , following code works: <?php session_start(); if ( !isset( $_session["origurl"] ) ) $_session["origurl"] = $_server["http_referer"]; $mysearchterm = $_server["http_referer"]; $whatiwant = substr($mysearchterm, strpos($mysearchterm, "=") +1); echo $whatiwant; ?>
Read more

Receive udp packets in android gstreamer -

i using eclipse juno in windows 7. doing programming on android 4.2 platform. want receive udp packets in gstreamer application. giving uri udp://127.0.0.1:1234 , sending file vlc player same computer. emulator giving message could not get/set setting from/on resource while in case of rtp, giving message no uri implementer found rtp ideas how receive streaming media in android?
Read more

Reversible shuffling a int array in java -

this question has answer here: reversible shuffle algorithm using key 4 answers i have int array of considerably large size. need shuffle array using key. should able obtain original array using same key. searched shuffle algorithms 1 found fisher yates not use key. the int array pixel values of image. need hide data it. hiding data after shuffling array enables accessing of data if 1 have key. fisher-yates uses pseudo-random number generator, can seed using key (look cryptographic prngs). reverse process, shuffle array of indices [0, n ) using same key, perform reverse shuffle.
Read more