Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Xinho
Starting Member
2 Posts |
 Posted - 2011-03-29 : 16:17:34
|
| i have a table "books" with id,name,datepublisher.. and so one..i need a select that returns the name's book thats in 1st value, the last value and the count off all of them.all in same select. i think i didnt learn enough...i have some other problems to solve... but im stuck in this |
|
|
Xinho
Starting Member
2 Posts |
Posted - 2011-03-29 : 16:37:22
|
| in http://sqlzoo.net/select.htm i put...SELECT count(*) as "TOTAL", (min(g.yr)) as "min name?", (max(g.yr)) as "max name?" from games gand i need the names sydnei in min... and London in max.... any1 help me? |
 |
|
|
|
|
|
need help in some select commands