Advertisement
nocturnalmk

[BP] komentari od korisnik

Apr 17th, 2013
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.26 KB | None | 0 0
  1. SELECT kom_id, (SELECT l_ime FROM lokacii WHERE l_id = komentari.l_id) AS lokacija, kom_vreme, kom_komentar FROM komentari WHERE k_id = 2 ORDER BY kom_vreme DESC
  2.  
  3. -- kako da se ogranice da se zemat samo prvite 2 reda?
  4. -- LIMIT ocigledno ne funkcionira kaj Oracle
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement