get First 100 rows of the table in mysql

MySQL and PostgreSQL SQL would use LIMIT like so:


SELECT column FROM table LIMIT 100

Comments

Post a Comment

Popular posts from this blog

How to retain the space of the td after hidding it in Jquery

Image
If you use the following code snippet to hide and show tds- the UI will get disturbed. The next corresponding td will get shifted to the hidden td space.    var tablevar="#"+myTable;  $(tablevar+' tr:eq('+i+')').find('td:eq(3)').show();    $(tablevar+' tr:eq('+i+')').find('td:eq(2)').show(); So how to retain the td space and still achieve the functionality. use the this code snippet.    var tablevar="#"+myTable; $(tablevar+' tr:eq('+i+')').find('td:eq(3)').css("visibility", "hidden");  $(tablevar+' tr:eq('+i+')').find('td:eq(2)').css("visibility", "hidden");  $(tablevar+' tr:eq('+i+')').find('td:eq(4)').css("visibility", "visible");
Read more

defining functions clojure

(defn saysomething      " i dont want to talk to you"      [name]      (str "why is it so?" name)) #'my-clojureproject1.core/saysomething => (println (saysomething "anjana") => (defn saymorethings "what do you want to hear" [name] (str "life is a box of chocolates" name)) #'my-clojureproject1.core/saymorethings => (println (saymorethings "nirosha")             ) life is a box of chocolatesnirosha nil
Read more

Jmeter and JUnit Testing.

Jmeter and JUnit Testing.  I was asked to test my junit class in a multi-threaded environment.  I choose JMeter.  Download-apache-jmeter-2.6.zip for the apache jmeter site.  Unzip the apache-jmeter-2.6.zip file.  Use Eclipse to create a Executable jar.  In Eclipse-click on Export  An Export Dialogue should appear. Click on Java->runnable JAR file. Select a main Class of your project.If you dont have create a dummy main class. Under-Library Handling:Select -"Extract required libraries into generated JAR" Click on Finish. A executable Jar will be created in the specified folder with lib extracted . Also remeber the JUNIT test version,i.eJunit3 or Junit4. Also take care of the libs--dont have duplicate libs in the jar.   In Jmeter;  Go to the installation folder of Jmeter  Browse Lib->junit here you will find a test.jar.Thats meant for example.  Drop your application jar h...
Read more