By JortK on June 30, 2009
We already discussed the methods to use TOP functions in MySQL and in MSSQL. In Oracle we make use of the ROWNUM function in the WHERE clause. To take our names table again in this example, to get the first 5 rows, make use of the following query: SELECT firstname,lastname FROM names WHERE ROWNUM <= [...]
Posted in How to | Tagged database, limit, oracle, query, top, trick
By JortK on June 28, 2009
Google has a really cool YouTube channel where they answer questions from users about their websites. This is a question I was also wondering what the answer was: Will Google penalize your site when all pages in your XML sitemap have the same priority? Well, Google gives the answer, see the video below:
Posted in Tech news | Tagged answer, google, priority, seo, sitemap, webmaster, xml
By JortK on June 28, 2009
Posted in Music | Tagged alter egosz, hardstyle, low-e, Music
By JortK on June 28, 2009
Fucking awesome hardstyle track: Josh & Wesz – Lipservice Radio!
Posted in Music | Tagged hardstyle, josh, Music, wesz
By JortK on June 27, 2009
Great new track by Deepack ft. D-Block & S-te-Fan:
Posted in Music | Tagged D-Block & S-te-Fan, dbstf, deepack, hardstyle, Music
By JortK on June 27, 2009
After I explained the MySQL method for getting the TOP N rows in a query it is time to explain the same for MS-SQL. Here we use the TOP function. To retrieve the first 5 rows from the names table, use the following query: SELECT TOP 5 firstname,lastname FROM names If you want to retrieve [...]
Posted in How to | Tagged limit, ms-sql, mssql, query, sql, top, trcik
By JortK on June 26, 2009
Just some videos for the King of Pop.
Posted in Movies | Tagged king of pop, michael jackson, tribute, video, youtube
By JortK on June 26, 2009
On the web I see a lot of questions of developers who are wanting to know how they can retrieve only the first N records in their queries. The answer is simple, LIMIT For example, if you only want to select the top 5 names from a names tables, use the following query: SELECT `firstname`,`lastname` [...]
Posted in How to | Tagged database, db, limit, MySQL, query, rownum, top, trick
By JortK on June 26, 2009
Cool new name of a track if you think about the fact he smashed Rihanna
Posted in Music | Tagged chris brown, rap, rihanna
By JortK on June 24, 2009
Trey Songz ft Mario & Joe – We Need 2 Roll
Posted in Music | Tagged joe, mario, trey songz