Profile cover photo
Profile photo
Akshay Sharma
18 followers
18 followers
About
Akshay's posts

Post has attachment
Operator Precedence in Sql.
In this article, we will see  Operator Precedence in Sql . When a complex expression has multiple operators, operator precedence determines the sequence in which the operations are performed. The order of execution can significantly affect the resulting val...

Post has attachment
ORDER BY clause
In this article, we will see the   ORDER BY clause  Sql . The  SQL ORDER BY clause  is used to sort the data in ascending or descending  order , based on one or more columns. Some database sorts query results in ascending  order  by default. Syntax SELECT c...

Post has attachment
wow.

Post has attachment
pl sql program for 'palindrome'
Write a program in PL/SQL to check whether a number is a palindrome or not. In this article, we will see the program for Palindrome in Pl/Sql. A  palindrome  is a word, phrase, number, or other sequence of characters which reads the same backward or forward...

Post has attachment
Reverse Of a Number
Write a program in PL/SQL to print the reverse of a number. According to the problem if a number  is 677 then it should print 776. Program Code: SQL> set serveroutput on SQL>Declare 2 num number:=&n; 3 rev number:=0; 4 Begin 5 while(num>0) 6 Loop 7 rev:=rev...

Post has attachment
PL/SQL Fibonacci Sequence
Write a PL/SQL code to get the Fibonacci Sequence. First, I will explain what is Fibonacci Sequence and how to get this series. So, Fibonacci Sequence is a series of numbers 0,1,1,2,3,5,8,13,21............. In Fibonacci Sequence, first and second elements a...

Post has attachment
PL/SQL factorial program
Write a program in PL/SQL to print the factorial of a number. In this post I will explain how to get the factorial of any given number. For that first you need to know what is the procedure to find the factorial of a number. To get the factorial of any give...

Post has attachment
Difference function
Given a  City  table, whose fields are described as +-----------+--------+ | Field | Type | +-----------+--------+ | ID | int(11) | | Name | char(35) | | CountryCode | char(3) | | District | char(20) | | Population | ...

Post has attachment
'Shortest' and 'Longest' cities name
Given a table STATION that holds data for five fields namely ID, CITY, STATE, NORTHERN LATITUDE and WESTERN LONGITUDE. +-----------+----------+ | Field       |   Type     | +-----------+----------+ | ID          | INTEGER    | | CITY        | VARCHA...

Post has attachment
Selecting 'Consonants '
Given a table  STATION  that holds data for five fields namely  ID ,  CITY ,  STATE ,  NORTHERN LATITUDE  and  WESTERN LONGITUDE . +-----------+----------+ | Field       |   Type     | +-----------+----------+ | ID          | INTEGER    | | CITY    ...
Wait while more posts are being loaded