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

javascript - Feed FileReader from server side files -

-
i´m starting customize/improve old audio editor project. can import audio tracks canvas via drag&drop computer. thing use audio tracks stored in server clicking on list of available tracks... instead of use <input type="file"> tags. how can read server side files filereader?ajax perhaps? in advance. this code file reader: player.prototype.loadfile = function(file, el) { //console.log(file); var reader = new filereader, filetypes = ['audio/mpeg', 'audio/mp3', 'audio/wave', 'audio/wav'], = this; if (filetypes.indexof(file.type) < 0) { throw('unsupported file format!'); } reader.onloadend = function(e) { if (e.target.readystate == filereader.done) { // done == 2 $('.progress').children().width('100%'); var onsuccess = function(audiobuffer) { $(el).trigger('audiee:fileloaded', [audiobuffer, file]); ...
Read more

java - How to create your own button and Use it with Scene Builder for javafx -

-
hello i've been curious know possible create own button, in example in photoshop. use "custom button" in place of default ones in scene builder. or there import function can use custom button? started using scene builder not familiar around can , cant do. thank you! being specific want mold imagine shape. use molded image button. not want use tradition button shape instead custom shape. im not sure if possible tips grateful! you can style button using css . if such styling insufficient purposes, can create custom button skin . if need additional properties button, can subclass button or buttonbase (this how javafx internally implements other button-like things additional properties such checkboxes, togglebuttons, radiobuttons, etc). either way scene builder doesn't care, there nothing special in scene builder , either option works scene builder. use scene builder place "normal" buttons in application's fxml files , set appropriate...
Read more

c++ - Drawing a circle in directx 9 -

-
i'm having hard time figuring out how draw circle in directx. i'm able draw triangle, imagined might able draw 1 rotating triangle in circle. however, i'm absolutely stumped. i've been scouring net hours no luck. can me out? here's code: main.cpp #include "engine.h" #include "box2d.h" #include "triangle2d.h" class myapp : public engine { public: box2d box2d; triangle2d triangle2d; void onstartup() override { box2d.new(10.0f, 10.0f, 100.0f, 100.0f, d3dcolor_argb(0xff, 0x00, 0x00, 0xff)); triangle2d.new(150.0f, 10.0f, 100.0f, 100.0f, d3dcolor_argb(0xff, 0xff, 0x00, 0x00)); } void onshutdown() override { box2d.delete(); triangle2d.delete(); } void ondraw() override { box2d.draw(); triangle2d.draw(); } void onmousedown(int x, int y) { debug("%d %d\n", x, y); } }; int winapi winmain(hinstance hinstance, hinstance hprevin...
Read more