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 | 30/11/2021

0 0

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/04/2021

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

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