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

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

AUTO INCREMENT PRIMARY KEY

Suprio Dutta

0 0

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

Coding Instructions To Prevent SQL-Injection

SQL-Injection is a very sensitive and very common technology to hack an application. I am describing a few techniques to make the SQL-Injection difficult. The main point of injection is a dynamic query....

Animesh Anand

0 0

SQL is not a Rocket Science

I am a Professional and at the inital days I completely hate Databases but I forgot to know that "Everything starts and ends with us".It means the INTEREST starts with us. Everybody knows this but none...

Annamalai M

0 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

SQL Programming Questions

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

28 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

I want to teach, how can I?

17 Answers

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

20 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