Answer / gopi muluka

Check this

DECLARE @Character TABLE
(
Ch VARCHAR(50)
)

INSERT INTO @Character
SELECT 'a' UNION
SELECT 'b' UNION
SELECT 'c' UNION
SELECT 'd' UNION
SELECT 'e' UNION
SELECT 'f' UNION
SELECT 'g' UNION
SELECT 'h' UNION
SELECT 'i' UNION
SELECT 'j' UNION
SELECT 'k' UNION
SELECT NULL

SELECT A.Ch,B.Ch,MAX(C.Ch)
FROM @Character A
CROSS JOIN @Character B
CROSS JOIN @Character C
WHERE ASCII(A.Ch)+1=ASCII(B.Ch) AND ASCII(A.Ch)% 3=1
AND ASCII(B.Ch)+1=ISNULL(ASCII(C.Ch),ASCII(B.Ch)+1) AND
ASCII(B.Ch)% 3=2
GROUP BY A.Ch,B.Ch

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

0 Answers   Facebook,

---

What is the difference between DTS and SSIS?

3 Answers   Allianz,

---

how you can list all the tables in a database?

0 Answers  

---

how you can get the list of largest tables in a database? : Sql server administration

0 Answers  

---

Can you explain what is sql server english query?

0 Answers  

---

How to insert new line characters into strings?

0 Answers  

---

Tell me about normalization in DBMS.

0 Answers   Honeywell, Zomato,

---

Do you know what is bit data type and whats the information that can be stored inside a bit column?

0 Answers  

---

can any body tell me how to know the password of current user in sql server

0 Answers   Crea, HCL,

---

Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?

3 Answers   Infosys,

---

What is Primary key and foreign key? Give an example

4 Answers   TCS,

---

Explain alternate key, candidate key and composite key in sql server?

0 Answers  

---