true

Learn SQL Programming from the Best Tutors

Affordable fees
1-1 or Group class
Flexible Timings
Verified Tutors

Search in

Interview questions based on "level", a pseudocolumn

Gavi Y.

05/01/2020 0 0

1. Write a query to get the below output,

1	11	21	31	..	..	91
2	12	22	32	..	..	92
3	13	23	33	..	..	93
						..
..	..	..	..	..	..	..
..	..	..	..	..	..	..
10	20	30	40			100

Ans:

select level,level+10,level+20,
level+30,level+40,level+50,
level+60,level+70,level+80,
level+90
from dual connect by level <=10;

2. Write a query to generate tables from 7 to 70.

Like, 7,14,21....8,16,24...9,18,27......70,140,210.

Ans:

Select a.a*b.b from
(select level+6 a from dual connect by level <=64) a,
(select level b from dual connect by level <=10) b;

And there are many more.............

0 Like 0 Dislike

Follow 1

Other Lessons for You

Top 10 SQL Concepts for Job Interview

1. SELECT and FROM: This is the “heart” of any SQL query - SELECT columns FROM table.2. WHERE: This acts as a filter and allows you to select only relevant rows based on conditions.3. GROUP...

Kavaiya Yashumar Amrutlal

0 0

Microsoft Outlook

Microsoft Outlook is the preferred email client used to access Microsoft Exchange Server email. Not only does Microsoft Outlook provide access to Exchange Server email, but it also includes contact, calendaring...

ITech Analytic Solutions

0 0

SQL Join Types

There are four basic types of SQL joins: inner, left, right, and full. The easiest and most intuitive way to explain the difference between these four types is by using a Venn diagram, which shows all...

ITech Analytic Solutions

0 0

SQL Union Vs Union ALL

SQL UNION vs UNION ALL Operator Usage UNION: UNION combines the result set of two or more queries into a single result set. UNION removes duplicate records (where all columns in the results are the same). UNION...

Umasankar Natarajan

0 0

SQL - Structured Query Language - DQL Commands - SELECT

Structured Query Language allows to store , manipulate, control and retrieve the information from Relational Database Management Systems. Following are some RDBMS products. Oracle Databse, Microsoft SQL...

Kasyap Kasyap

2 0

Find SQL Programming Training near you

Looking for SQL Programming Training?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

Looking for SQL Programming Classes?

The best tutors for SQL Programming Classes are on UrbanPro

Select the best Tutor
Book & Attend a Free Demo
Pay and start Learning

Book a Free Demo

Learn SQL Programming with the Best Tutors

The best Tutors for SQL Programming Classes are on UrbanPro