Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

TCS SQL PLSQL Interview Questions
Questions Answers Views Company eMail

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

 3 6640

How to count the no of records of a table without using COUNT function?

 11 24861

wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?

 4 18296

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

 9 8762

What is the difference between UNIQUE KEY and UNIQUE INDEX?

 3 7508

What is the differnce between view and materialized view

 4 7517

What is dynamic SQl and how you will create and execute dynamic sql?

 2 6315

Query for second maximum salary in each in each department

 15 34249

query to retrive the employees whose sal is greater than avg sal

 10 12228

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?

13 19712

select sal from emp group by sal

 3 5083

counting the no.of characters occurs in a string by using pl/sql function

 1 5504

What is the relation b/w view and trigger

 3 14671

how to create temparary sequence

2 6762

What is the Difference between Procedure and Function.Can we call a Function in a DML?

 2 7024

Post New TCS SQL PLSQL Interview Questions


TCS SQL PLSQL Interview Questions


Un-Answered Questions

What are all important modules in python reuired for a data science ?

451

What is significance level?

3

What are the ways through which you pass value to an program from JCL?

1023

How do you delete a row?

340

What is React?

181




write the test senario on opening door in the flow diagram format

858

Is treemap sorted?

520

Explain about reporting services of MYSQL?

606

Explain the 'page lifecycle' of an ASP.NET MVC?

616

In Which Specs Arrays, Tables & Constants Are Defined?

694

What is wcf ipc binding type?

467

What is difference between first level cache and second level cache in hibernate?

179

Explain the use of data class in Kotlin?

133

Is there any sample c# code for simple threading?

556

What's the difference between int and integer in java?

529