Dispaly top n rows in SQL | Display last n rows in SQL | Display nth Row in SQL

 

For Explanation watch video::





* rownum

=======







fetching top 1,2,5 rows



fetching the 2nd row from table






Fetch last two roes





Comments

Post a Comment

Popular posts from this blog

Print Prime Numbers Hackerrank Solution - PL/SQL

Image
 Print Prime Numbers Hackerrank Solution - PL/SQL For Explanation watch video: Code:: set serveroutput on; declare output clob := ''; co number; begin  for i in 2..1000 loop      co := 0;      for j in 2..(i/2) loop        if mod(i,j)=0          then            co := 1;            exit;         end if;     end loop;     if co = 0      then        output :=  output || i ||'&';     end if;     end loop;     dbms_output.put_line(substr(output,1,length(output)-1)); end; /
Read more

how to store html form data in mysql database using hibernate

Image
 how to store html form data in mysql database using hibernate For Explanation Watch Video :: Directory Structure: Pom.xml <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.test</groupId> <artifactId>Servlet-Hibernate</artifactId> <packaging>war</packaging> <version>0.0.1-SNAPSHOT</version> <name>Servlet-Hibernate Maven Webapp</name> <url>http://maven.apache.org</url> <properties> <maven.compiler.source>1.9</maven.compiler.source> <maven.compiler.target>1.9</maven.compiler.target> </properties> <dependencies> <dependency> <groupId>junit</groupId> <artifactId>junit...
Read more