By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
| ID | NewsTitle | NewsRoleId | URL |
|---|---|---|---|
| 1 | Test | 124 | http://ournews.com/View;newsId=2;OrderId=1;pt=5 |
| 2 | Test | 138 | http://ournews.com/View;newsId=1;OrderId=1;pt=5 |
| 3 | Test2 | 100 | http://ournews.com/View;newsId=4;OrderId=1;pt=5 |
| 4 | Test2 | 105 | http://ournews.com/View;newsId=3;OrderId=1;pt=5 |