Sql server Distinct Rows -

-

i have table contains data use sql server 2008 r2

+-----+------+--------+-------+------+-------+ | id  | kind |  date  | price | type | amount|  +-----+------+--------+-------+------+-------+ | 525 |  32  |1/1/2016|  240  |   0  |  3000 | | 525 |  32  |1/1/2016|  380  |   1  |  3000 | | 525 |  32  |1/1/2016|  240  |   0  |  4000 | | 525 |  32  |1/1/2016|  380  |   1  |  4000 | +-----+------+--------+-------+------+-------+

how can result?

+-----+------+--------+-------+------+-------+ | id  | kind |  date  | price | type | amount|  +-----+------+--------+-------+------+-------+ | 525 |  32  |1/1/2016|  240  |   0  |  3000 | | 525 |  32  |1/1/2016|  380  |   1  |  4000 | +-----+------+--------+-------+------+-------+

will not do?

select distnct id, kind, date, price, type, amount dbo.yourtable

Comments

Post a Comment

Popular posts from this blog

php - How to register a post type and taxonomy in WordPress and display in a page/single post -

-
i have question wordpress register post type: how can register post type portfolio ? for example: in wordpress dashboard, can register post type , taxonomy. after want create page display portfolio , taxonomies (portfolio.php) , display single portfolio in (single-portfolio.php). can explain me please? you can use various methods : create in theme archive-#postypename#.php (best one) create page custom template name , put there code. for single page can, write, create single-#postypename#.php in theme. here's helpful link: how create custom post types archive page in wordpress
Read more

database - How many Observations in SAS Sample Data Output -

-
i have sample sas output , need find out how many observations , compute t-statistic beta1. can me started on how go doing this? sample sas output to number of obs in dataset can run code. data _null_; put nobs=; stop; set sashelp.class nobs=nobs; run; a proc reg give summary statistics need, namely, t-value, beta1 , beta null, intercepts of regression equation. here simple easy follow example http://support.sas.com/documentation/cdl/en/statug/63962/html/default/viewer.htm#statug_reg_sect003.htm
Read more

emulation - Android map show my location didn't work -

-
i have been struggle current location in google map, tried official map demo, not working also. shows getmylocation button on upper right, didn't show blue dot on map current location. here code , i'm using emulator target api 23, guess may emulator's problem since code download directly github. advice appreciated. [screenshot][1] package com.example.mapdemo; import com.google.android.gms.maps.googlemap; import com.google.android.gms.maps.googlemap.onmylocationbuttonclicklistener; import com.google.android.gms.maps.onmapreadycallback; import com.google.android.gms.maps.supportmapfragment; import android.manifest; import android.content.pm.packagemanager; import android.os.bundle; import android.support.annotation.nonnull; import android.support.v4.app.activitycompat; import android.support.v4.content.contextcompat; import android.support.v7.app.appcompatactivity; import android.widget.toast; /** * demo ...
Read more