SQL test

[LazyRohit]

21 minutes ago, Amrita said:

Same thing cheppanu 

Chepptam kadu prove it antunna DBAS

[Amrita]

45 minutes ago, LazyRohit said:

Chepptam kadu prove it antunna DBAS

That  query works i already tested in oracle DB for all schemas.  Last condition customer id =100  loop lo rasukovali.  Direction istaru kani proc rasi pettanu nenu. Nadi naku rasukovadame chirak @LazyRohit 

Also, i am a java dev ..DBA's can give better optimized sol than me. Ltt for others.

[Katara]

31 minutes ago, Amrita said:

Same thing cheppanu 

Mari 2&3 ?? khalilu purinchumu , anni prashnalaku samadhanalu raya valenu.

[Amrita]

21 minutes ago, Katara said:

Mari 2&3 ?? khalilu purinchumu , anni prashnalaku samadhanalu raya valenu.

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 (
   select id
   from numbers 
   where id >= 0 -- this is the minimum
)
select nr.id as missing_sequence_value
from number_range nr
  left join CLIENT t on t.id = nr.id
where t.id is null
order by 1;

 

@4Vikram

 @Katara  : Badhakasturalito rayincharu ga 

3rd question ardham kaledu. 

[Amrita]

52 minutes ago, LazyRohit said:

thread is nice good disco nenu ikkada lenu anukoni replies ivandi 

Oho tamaru DBA na ? Inkem kasta badhakam vadili optimized solution cheppachu ga ? @LazyRohit 

[JollyBoy]

TS unnava

[LazyRohit]

13 minutes ago, Amrita said:

Oho tamaru DBA na ? Inkem kasta badhakam vadili optimized solution cheppachu ga ? @LazyRohit 

nah aws stack meeda 

neninthe lo brahmi spoof 

[LazyRohit]

12 minutes ago, JollyBoy said:

TS unnava

thread lo cheppina solutions trying anta 

 

[JollyBoy]

3 minutes ago, LazyRohit said:

thread lo cheppina solutions trying anta 

 

Aipotundi aipotundi le

[Amrita]

20 minutes ago, LazyRohit said:

nah aws stack meeda 

neninthe lo brahmi spoof 

 

19 minutes ago, JollyBoy said:

Aipotundi aipotundi le

Na code review chesava sql expert @JollyBoy

[JollyBoy]

9 minutes ago, Amrita said:

 

Na code review chesava sql expert sir 

Review aa.. $90/hr optimization included

[Amrita]

2 minutes ago, JollyBoy said:

Review aa.. $90/hr optimization included

[4Vikram]

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

54 minutes ago, JollyBoy said:

TS unnava

Namaskaram Pedha Bala Murali Krishna Garu 

[4Vikram]

4 hours ago, aakathaai said:

Select * from antha varake gurthundi baa

poi pandu ki votes esko po

4 hours ago, riashli said:

Off topic, how are you? Long time

Ltt

Hey Vaishu how are you vunty... Yes long time, DB boring aipoindi. Everything else is good, how are things with you? How are pillakayals?

[texas]

4 hours ago, 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?

Lyt