UrbanPro
true

Find the best tutors and institutes for SQL Programming

Find Best SQL Programming Training

Please select a Category.

Please select a Locality.

No matching category found.

No matching Locality found.

Outside India?

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 Dislike
Follow 1

Please Enter a comment

Submit

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
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
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
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
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
0
X

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

Looking for SQL Programming Classes?

Find best SQL Programming Classes in your locality on UrbanPro

Post your learning requirement

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more