true

Find the best tutors and institutes for SQL Programming

Find Best SQL Programming Training

Search for topics

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

DBMS - SQL - Any/All

All - Operator SELECT empno, sal FROM emp WHERE sal > ALL (1999, 2999, 3999); Output of Above query is same as below query SELECT empno, sal FROM emp WHERE sal > 1999 AND sal > 2999...

Radhe Shyam | 02 Apr

0 0

How to use joins in SQL

What are Joins in SQL? Joins in SQL are used to combine rows between two or more tables. Joins are used in SQL when user need to extract data between two or more tables based on a related column. Joins...

Sagar Waikar | 02/12/2020

0 0

Data Integrity in SQL Server

It is often told, data without integrity is just numbers. There are different situations like1. When a user enters data which is not in proper range or invalid2. A wrong DML operation is attempted by...

Pritam Chatterjee | 14/07/2020

0 0

SQL

Structured query language-It is a language to interact with the database. Database-It is a collection of data's in the form of tables. Tables-Collection of rows and columns Rows are also called as tuples...

Rana Vikram Singh | 10/01/2020

1 0

What is DBMS and RDBMS

Database Management Systems A database is a collection of data or records. Database management systems are designed to work with data. A database management system (DBMS) is a software system that uses...

Amit Patil | 15/04/2019

0 0

Find SQL Programming Training near you

Looking for SQL Programming Training?

Find best SQL Programming Training in your locality on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

Looking for SQL Programming Classes?

Find best tutors for SQL Programming Classes by posting a requirement.

Post a learning requirement
Get customized responses
Compare and select the best

Post your learning requirement

Looking for SQL Programming Classes?

Find best SQL Programming Classes in your locality on UrbanPro

Post your learning requirement

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

Interview questions based on "level", a pseudocolumn

Other Lessons for You

Looking for SQL Programming Training?

Related Questions

Looking for SQL Programming Classes?

Looking for SQL Programming Classes?

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