Search:

Select Query Examples and Tutorials

Home » Articles » Oracle

4K
views

Display 2 items having lowest current stock
Oracle	Dec 06 Imogen Brown

15K
views

Write a query to subtract days from todays date
Oracle	Nov 22 Adalricus Fischer

7K
views

Display average marks of students using avg() function and also round it using round().
Oracle	Nov 11 Adalfredo Fischer

4K
views

Write a query to calculate the Date difference
Oracle	Oct 13 Adriane Miller

2K
views

Display customers having city other than gujarat and mp using not in
Oracle	Oct 11 Adelbert Fischer

6K
views

Example to display records of student pass in all subjects and marks are greater than 60 in maths
Oracle	Sep 03 Rhys Evans

3K
views

Display student details born in year 1980 to 1982 using to_char() function
Oracle	Sep 02 Lucas Silva

5K
views

Example of natural join
Oracle	Sep 01 Leticia Silva

2K
views

Example of outer join to display items which are sold and not sold till today
Oracle	Aug 14 Ballard Schmidt

4K
views

Example to concatenate a string using select query
Oracle	Aug 09 Anselma Schmidt

3K
views

Write a query to Calculate the month difference
Oracle	Aug 08 Harrison Evans

5K
views

Write a query to find the last day of the month
Oracle	Aug 05 Raimond Fischer

3K
views

Display customers detail in a ascending order of customer name using order by clause in a select que...
Oracle	Jul 26 Madison Campbell

3K
views

Example to find total value of each item based on current stock using multiplication operator in sel...
Oracle	Jul 24 Isabel Hughes

2K
views

Display invoice items of invoice id I010
Oracle	Jul 21 Sophia Hughes

3K
views

Display top 3 highest item price from item table
Oracle	Jul 15 Zak Brown

4K
views

Write a query to change the case of strings using lower and upper function
Oracle	Jul 14 Matheus Silva

2K
views

Example to find employees from state 'Delhi' using select query
Oracle	Jul 10 Bailey Evans

5K
views

Display items having item price between 100 to 500 using select query
Oracle	Jun 26 Alice Miller

2K
views

Display invoices having items greater than or equal to 3
Oracle	May 25 Abelerd Fischer

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us

DMCA.com

Copyright © 2008-2012