Hello, I am trying to get Sum of three columns from three different table and get results table using SQL.
Suppose here are my tables
Table 1: raw_item_fcst
Table 2. Raw_item
Table 3 . inventory_data
I try to write query to fetch data from these tables using subquery , Here is my sub query...
I have Two Tables, from one table I want to select all column but from the second table I want to fetch only one column with average value using avg function with related id
How can I achieve this using SQL query?...
I am new to Database systems and I don't really have the best lecturer and we are learning about Relational algebra and relational calculus, not many videos or help online.
Please can someone assist me with this topic as i would like to get further knowledge...
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?...
If, we assign the rank to the column
Name. . . . . . Rank
A. . . . 1
C . . . 3
When the user adds the data, the rank is saved in DB(database).
How to update the rank in DB, when user delete the data using knockout?
On click of delete, there is one function called
And in that function table row<tr> is removed using knockout.
Example: if we delete row B its order will be, -1 as deleted item will have rank/order -1 and order/rank of c will be 2
Is, there any alternative way to reset the column value in SQL or something else?
Please, suggest me
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:...
I am trying to run the below query which works fine without AVG function, but when using AVG it doesn't work, here is the query...
Hi. Suppose, I have for example this string field in my sql database "never say never" and I want to count how many times "never" appear in the string in sql server 2008, so how I can check that.