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

Microsoft Excel

Software developed and manufactured by Microsoft Corporation that allows users to organize, format, and calculate data with formulas using a spreadsheet system broken up by rows and columns. Microsoft...

ITech Analytic Solutions

0 0

New features of Oracle 23ai

2 of the new features of Oracle 23ai (previously Oracle 23c) with respect to SQL are discussed. 1. Boolean datatype included in SQL. Previously, boolean was not part of SQL, but belonged to Oracle...

Vinayak V Dabgar

0 0

Database Origins

The need for a database originates from the fact that computers are dumb devices having batman like abilities which can be smartly be utilised by feeding it the right content. That is, for example, consider...

Manish Joshi

0 0

WebSphere

WebSphere is a set of Java-based tools from IBM that allows customers to create and manage sophisticated business Web sites. The central WebSphere tool is theWebSphere Application Server (WAS), an application...

ITech Analytic Solutions

0 0

Primary Key VS Unique Key In Database.

PRIMARY KEY UNIQUE KEY Primary key is a set of one or more fields/columns of a table that uniquely identify a record in database table. Primary keys must contain unique values. Unique-key...

Umasankar Natarajan

0 0

Find SQL Programming Training near you

Online SQL Training

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

SQL Programming Questions

Which is a good reference book to learn SQL and database from basics?

20 Answers

I need your help to choose my career as I have three years of gap between my education. I know SQL. Can...

28 Answers

I want to teach, how can I?

17 Answers

How do I become master in SQL server? I am looking for real time case studies to write queries, stored procedures etc.

5 Answers

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

Learn SQL Programming with the Best Tutors

The best Tutors for SQL Programming Classes are on UrbanPro

I am a Student I am a Tutor
Name*	Please enter your full name. Please enter institute name.
Email*	Please enter your email address.
Phone*	Please enter a valid phone number.
Location*	Please enter a pincode or area name.
City*	Please enter city name.
Category*	Please enter category.
Gender*	Male Female Please select your gender.
Email ID/ Mobile No.*	Please enter either mobile no. or email.
Enter Password*	Please enter OTP Please enter Password Sorry, this phone number is not verified, Please login with your email Id.

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

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

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