tricky SQL questions please

[mettastar]

1 minute ago, rakeshchinna said:

Truncate Table 

thanks.. never heard of identity column..  sequence number antaga

[rakeshchinna]

15 minutes ago, mettastar said:

@rakeshchinna

I still have doubt on using rank or row_number() confirm chesukovalii experts row_number() ani chepparu

[rakeshchinna]

Just now, mettastar said:

thanks.. never heard of identity column..  sequence number antaga

Identity column vinaledu ante needi PL/SQL back ground aah broo

[mettastar]

1 minute ago, rakeshchinna said:

I still have doubt on using rank or row_number() confirm chesukovalii experts row_number() ani chepparu

u r right may be we have to use row_number() to avoid duplication

[mettastar]

Just now, rakeshchinna said:

Identity column vinaledu ante needi PL/SQL back ground aah broo

ledu .. ETL side .. but oracle tho work chesi chaala rojulu aindhi

[former]

6 minutes ago, mettastar said:

Nulls meda join avadhu .. so NVL use chesi convert null to some default to join

nice

[former]

9 minutes ago, Srimantudu said:

Resetting Identity column on a table.

what is this concept ???

[mettastar]

inka questions please

[former]

Assume the table don't have any date or timestamp data type or don't have time or date representative fields. How to do know when the table last  insert or update happened ?

[Suhaas]

Write a T-SQL to fetch first Name, Initial, Last Name and Suffix from Full Name Column

EmployeeID	FullName
1	Nancy Davolio
2	Andrew W Fuller Jr
3	Janet Leverling
4	Margaret Peacock
5	Steven Buchanan
6	Michael J Suyama Jr
7	Robert T King III
8	Laura Callahan
9	Anne Dodsworth

Expected Output

EmployeeID	FullName	FirstName	Initial	LastName	Suffix
1	Nancy Davolio	Nancy		Davolio
2	Andrew W Fuller Jr	Andrew	W	Fuller	Jr
3	Janet Leverling	Janet		Leverling
4	Margaret Peacock	Margaret		Peacock
5	Steven Buchanan	Steven		Buchanan
6	Michael J Suyama Jr	Michael	J	Suyama	r
7	Robert T King III	Robert	T	King	III
8	Laura Callahan	Laura		Callahan
9	Anne Dodsworth	Anne		Dodsworth

 

 

[mekapichal_mnthmkura]

53 minutes ago, mettastar said:

what is the relation vuncle.. question is not clear... 

24567898

->12345668

 

how are these two related? 

first set lo first dhi second set lo first dhi ala relate chesava ?

8 rows unnay.. aa data set lo..

4 pakkana migitha 4 ravali..

pivoting  type annattu.. cheyy

[mettastar]

14 minutes ago, former said:

Assume the table don't have any date or timestamp data type or don't have time or date representative fields. How to do know when the table last  insert or update happened ?

Logs chudali

[mettastar]

10 minutes ago, Suhaas said:

Write a T-SQL to fetch first Name, Initial, Last Name and Suffix from Full Name Column

EmployeeID	FullName
1	Nancy Davolio
2	Andrew W Fuller Jr
3	Janet Leverling
4	Margaret Peacock
5	Steven Buchanan
6	Michael J Suyama Jr
7	Robert T King III
8	Laura Callahan
9	Anne Dodsworth

Expected Output

EmployeeID	FullName	FirstName	Initial	LastName	Suffix
1	Nancy Davolio	Nancy		Davolio
2	Andrew W Fuller Jr	Andrew	W	Fuller	Jr
3	Janet Leverling	Janet		Leverling
4	Margaret Peacock	Margaret		Peacock
5	Steven Buchanan	Steven		Buchanan
6	Michael J Suyama Jr	Michael	J	Suyama	r
7	Robert T King III	Robert	T	King	III
8	Laura Callahan	Laura		Callahan
9	Anne Dodsworth	Anne		Dodsworth

PS: No googling

 

Substring and length batti case statement rayali

[ronitreddy]

24 minutes ago, mettastar said:

ledu .. ETL side .. but oracle tho work chesi chaala rojulu aindhi

Ee tool vuncle?

[rakeshchinna]

23 minutes ago, former said:

Assume the table don't have any date or timestamp data type or don't have time or date representative fields. How to do know when the table last  insert or update happened ?

identity column use cheyachu insert check cheyadaniki then use scope_identity function