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

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

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