Jump to content

SQL test

4Vikram

By 4Vikram
in Discussions

 Share

Recommended Posts

  • Replies 32
  • Created
  • Last Reply

Top Posters In This Topic

  • Amrita

    9

  • LazyRohit

    4

  • 4Vikram

    3

  • JollyBoy

    3

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

aakathaai
aakathaai

Select * from antha varake gurthundi baa

Amrita
Amrita

Second answer: Tested in oracle and it works   with numbers as (    select level - 1 as id    from dual    connect by level <= (select max(id) + 2 from CLIENT) ), number_range as

Amrita LEGEND

Amrita

Posted
Posted
12 minutes ago, 4Vikram said:

andariki dhanyavadamulu @Amrita man nuvu chepinate try chesna man nenu kuda adhe working anukunta and updated also.. Trank you my fellow dbians. 

Namaskaram Pedha Bala Murali Krishna Garu 

Cool 👍

Link to comment
Share on other sites
  • 4 years later...
thata Side Hero

thata

Posted
Posted
On 8/13/2019 at 9:06 AM, 4Vikram said:

A database has > 1000 tables and there are about few hundred tables that have column called "CustomerID". Write a query to get the list of tables that have 1 more or rows for CustomerID = 100.(dynamic SQL)

2) Given a sequence A-01 to A-099 find the missing sequence(use dynamic or T-sql)(the numbers are in string how do ypu find it)

3)  how do you enforce rules by giving an example

 

any one?

No

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...