Answer Posted / gopi muluka

DECLARE @STR VARCHAR(50),
@Char VARCHAR(10),@N INT, @CNT INT
DECLARE @TAB TABLE (VAL VARCHAR(30), CNT INT)

SET @STR='A,B,C,D,E,F,C,A,S,K,C,B'
SET @CHAR=''
SET @N=1
SET @CNT=1
WHILE @N>0
BEGIN
PRINT @STR
SET @CHAR=SUBSTRING(@STR,1,CHARINDEX(',',@STR)-1)
IF NOT EXISTS(SELECT 1 FROM @TAB WHERE VAL=@CHAR)
INSERT @TAB VALUES (@CHAR,@CNT)
SET @STR=SUBSTRING(@STR,CHARINDEX(',',@STR)+1,115)
IF CHARINDEX(@CHAR,@STR)>0
BEGIN
UPDATE @TAB
SET CNT=CNT+1
WHERE VAL=@CHAR
END
SET @N=CHARINDEX(',',@STR)
PRINT @N
END
SELECT * FROM @TAB

What is a record in pl/sql?

1063

---

Explain the insert into statements in sql?

932

---

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

984

---

Is join and inner join the same?

940

---

what is sp_pkeys? : Transact sql

1098

---

what are the different tables present in mysql? : Sql dba

922

---

What is the trigger in sql?

898

---

what is the different between now() and current_date()? : Sql dba

929

---

Why triggers are used?

936

---

Does sql between include endpoints?

951

---

How to avoid using cursors?

1035

---

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1380

---

What is data profiling in sql?

1014

---

What is the best partition size for windows 10?

944

---

Explain commit, rollback and savepoint.

931

---