Can we use loop in sql?
Answer / Sangeeta Yadav
No, SQL (Structured Query Language) does not support loops. SQL is a declarative language designed for data manipulation and retrieval, while loops are procedural constructs used to control the flow of execution in programming languages.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are hotfixes and patches?
Write a query to find the names of users that begin with "um" in sql?
List out the acid properties and explain?
Why do we use view in sql?
I want to execute a piece of code before calling a procedure. How to achieve it?
What Is a Trigger? How Do You Use It?
What is sql indexing?
How to trace the errors in pl/sql block code?
how to escape special characters in sql statements? : Sql dba
there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?
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?
What is pivot query?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)