2437 1
Error while Updating or Deleting data using RowNum in Oracle 11g

Hi, how can I use "ROWNUM" to delete a specific row? just ROWNUM only not ROW_NUMBER() or ROWID

I can select specific row using ROWNUM but I cannot use it in DELETE or UPDATE operation.

Sample Query in Select Statement:

...
Type
Question
2428 0
Best SQL Server Tools for SQL Developers.
In this article, we have provided list of best SQL Server Tools (paid or free), which you can use with SQL Server with its features.
Type
Article
2370 1
What is SQL Query to get dates between two dates?

Hello, I have one more question related to SQL query, in which I would like to know how can I get all dates between two dates using SQL Query. For example, I have start date = 10/02/2022 and end date = 14/02/2022, then query must return dates 11/02/2022, 12/02/2022 and 13/02/2022.

I am using SQL Server for this, but I think SQL query will remain the same for oracle or MySQL too.

...
Type
Question
2358 2
How to access the substring from the string in sql?

I need to access substring from a string using SQL, how can i achieve it in SQL server?

Suppose my string in "Hello World in C" and i want "World" from it, how can i do that using SQL query?

...
Type
Question
2243 2
Can i have example of declare table and temp table in sql ? and how the update operation can be used on it ?

Can i have example of declare table and temp table in sql ? and how the update operation can be used on it with real life scenario ?

 

...
Type
Question

1949 0
How to Edit More than 200 rows in SQL Server
In this article, I have mentioned how we can increase limit to edit more than 200 rows in sql server using SSMS.
Type
Article
1933 0
Delete (Drop) Database in SQL Server
In this article, I have provided step by step procedure to delete or drop database in sql server using SSMS or using drop database using SQL query.
Type
Article
1913 0
Get Last 3 months records in SQL Server
In this article, I have mentioned how we can Get Last 3 months records in SQL Server with an example
Type
Article
1609 2
How to check if Columns exits in SQL Server table?

Hello, I am still learning SQL and SQL Server, so I would like to know how can I verify or check if a column exists in the database table using SQL Query in SQL Server?

...
Type
Question
1469 1
I have deleted my database by accidentially in sql server 2017 is there is any way to recover it?

Hi, I have deleted my database by accidentially in sql server 2017 is there is any way to recover it? Thanks.

...
Type
Question

Page 9 of 11