sql query error

[alin19]

select * from (select id_port, id_bo, simbol, volum  from `portofolii` where id_bo='se28'  order by `id_port` desc) group by `id_port`

 

 

what i have wrong in this query?

here:

( select id_port, id_bo, simbol, volum  from `portofolii` where id_bo='se28'  order by `id_port` desc)  i try order desc all my database and there group by simbol,

[BlueSkyIS]

select id_bo, simbol, volum  from `portofolii` where id_bo='se28' order by `id_port` desc, `simbol` asc

[alin19]

yes this works, but just turns my database upside down

 

 

now i need to make something like this:

 

 

select * from (select id_port,id_bo, simbol, volum  from `portofolii` where id_bo='se28' order by `id_port` desc, `simbol` asc) group by `simbol`

 

to select from this query, but i get this error:

 

#1248 - Every derived table must have its own alias

[BlueSkyIS]

there is no need for a sub-select, but i don't think you'll get the results you expect:

 

select id_port,id_bo, simbol, volum  from `portofolii` where id_bo='se28' group by A.simbol order by `id_port` desc, `simbol` asc

[alin19]

this turn the same as select * from `portofolii` order by `simbol`

 

 

returns the first record for each simbol,

 

 

i need to get the last record for each simbol,

 

so i thougth to turn the database upside down and then search to get the last record instead of first

[alin19]

SELECT sum_column1, test2, test3

FROM (SELECT id_port AS sum_column1, id_bo AS test2, simbol AS test3

FROM portofolii ORDER BY `id_port` DESC ) AS table GROUP BY test2

 

this seams to work; 10x