Unanswered questions in Database

0 votes
0 answers

ORA-00904: invalid identifier

I am getting this error while doing ...READ MORE

May 20 in Database by Kichu
• 19,040 points
47 views
0 votes
0 answers

phpMyAdmin - Error > Incorrect format parameter?

I used this command: select database > ...READ MORE

May 19 in Database by Kichu
• 19,040 points
91 views
0 votes
0 answers

Access denied for user 'root@localhost' (using password:NO)

I wanted to run WordPress and it ...READ MORE

May 8 in Database by Kichu
• 19,040 points
171 views
0 votes
0 answers

How to add Indian Rupee Currency symbol in Google Spreadsheet

I need to add Indian Rupee Currency ...READ MORE

Apr 7 in Database by Edureka
• 13,640 points
27 views
0 votes
0 answers

Unprotect workbook without password

I have a popular VBA code to ...READ MORE

Apr 7 in Database by Edureka
• 13,640 points
25 views
0 votes
0 answers

EXCEL - How to create a custom cell format for an Australian phone number: xxxx-xxx-xxx

Australian mobile phone (cell phone) and land ...READ MORE

Apr 7 in Database by Edureka
• 13,640 points
46 views
0 votes
0 answers

Convert a vertical data in a excel sheet with one header

I have a problem converting a long ...READ MORE

Apr 7 in Database by Edureka
• 13,640 points
15 views
0 votes
0 answers

Datatables export Excel

I'm exporting the datatables in csv. And ...READ MORE

Apr 7 in Database by Edureka
• 13,640 points
78 views
0 votes
0 answers

Excel formula for reverse percentage calculation

I have a calculation which I am ...READ MORE

Apr 7 in Database by Edureka
• 13,640 points
21 views
0 votes
0 answers

Why should I use the DIM statement in VBA or Excel?

So there is a question on what DIM is, but I ...READ MORE

Apr 7 in Database by Edureka
• 13,640 points
14 views
0 votes
0 answers

How do I merge two rows in Excel?

Hi I'm not even sure if this ...READ MORE

Apr 7 in Database by Edureka
• 13,640 points
21 views
0 votes
0 answers

Excel - Find how many cells are in a range

For each cell in the column I ...READ MORE

Apr 7 in Database by Edureka
• 13,640 points
19 views
0 votes
0 answers

Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel ...READ MORE

Apr 7 in Database by Edureka
• 13,640 points
15 views
0 votes
0 answers

Make sentence from data in cells in Excel

I have a form with three cells ...READ MORE

Apr 6 in Database by Edureka
• 13,640 points
28 views
0 votes
0 answers

How do I merge two rows in Excel?

Hi I'm not even sure if this ...READ MORE

Apr 4 in Database by gaurav
• 13,460 points
13 views
0 votes
0 answers

How to split a string of text in excel based on a given word?

I have a list of combinations of ...READ MORE

Apr 4 in Database by gaurav
• 13,460 points
47 views
0 votes
0 answers

Check Excel file format from PowerScript not relying on file extension

We have a number of Excel files ...READ MORE

Mar 31 in Database by Edureka
• 13,640 points
18 views
0 votes
0 answers

in MS excel find first non n/a value in row

I have dates (Jan-2014 in cell A1, ...READ MORE

Mar 30 in Database by Edureka
• 13,640 points
14 views
0 votes
0 answers

How to loop in excel without VBA or macros?

Is it possible to iterate (loop) a ...READ MORE

Mar 30 in Database by Edureka
• 13,640 points
167 views
0 votes
0 answers

How would I use excel to generate a large update sql statement?

I know there's a way to have ...READ MORE

Mar 30 in Database by Edureka
• 13,640 points
45 views
0 votes
0 answers

Laravel - Datatables export excel from filtered data

Hello i would like to export data ...READ MORE

Mar 28 in Database by Edureka
• 13,640 points
647 views
0 votes
0 answers

Count colored cell on excel automatically

I'm trying to count the number of ...READ MORE

Mar 28 in Database by Edureka
• 13,640 points
16 views
0 votes
0 answers

Modify an existing Excel file using Openpyxl in Python

I am basically trying to copy some ...READ MORE

Mar 25 in Database by Edureka
• 13,640 points
104 views
0 votes
0 answers

Excel PERCENTRANK.INC in Javascript

Is there a way to get the ...READ MORE

Mar 23 in Database by Edureka
• 13,640 points
22 views
0 votes
0 answers

Merging Two excel files as two sheets in one workbook in java

I have two xlsx files at folder ...READ MORE

Mar 10 in Database by Edureka
• 13,640 points
72 views
0 votes
0 answers

How to change column datatype in SQL database without losing data?

I have a SQL Server database, and ...READ MORE

Feb 25 in Database by Vaani
• 7,020 points
51 views
0 votes
0 answers

What's the difference between a temp table and table variable in SQL Server?

We can build temp tables in SQL ...READ MORE

Feb 25 in Database by Vaani
• 7,020 points
47 views
0 votes
0 answers

Order Of Execution of the SQL query

I'm not sure what sequence this query ...READ MORE

Feb 25 in Database by Vaani
• 7,020 points
51 views
0 votes
0 answers

SELECT.... WHERE... OR

Is there a method to choose data ...READ MORE

Feb 25 in Database by Vaani
• 7,020 points
31 views
0 votes
0 answers

Select .... where .... OR?

Is there a method to choose data ...READ MORE

Feb 24 in Database by Hemant
• 140 points
21 views
0 votes
0 answers

Testing question and answer

This category discusses everything related to SQL/ ...READ MORE

Feb 24 in Database by anonymous
• 140 points
57 views
0 votes
0 answers

Duckworth-Lewis-Stern calculator to calculate the revised target

With the Cricket World Cup going on, ...READ MORE

Feb 24 in Database by Edureka
• 13,640 points
22 views
0 votes
0 answers

If Cell Starts with Text String... Formula

I have formula that checks if the ...READ MORE

Feb 24 in Database by Edureka
• 13,640 points
25 views
0 votes
0 answers

How to import JSON file to Excel without coding?

Let's say you have a file named input.json which ...READ MORE

Feb 24 in Database by Edureka
• 13,640 points
33 views
0 votes
0 answers

How to get address, Column Name and Row Name of all marked rows in Excel table as rows in new worksheet

 need the row/column combinations marked with an ...READ MORE

Feb 24 in Database by Edureka
• 13,640 points
83 views
0 votes
0 answers

How Stuff and 'For Xml Path' work in SQL Server?

Table is: Id Firstname 4 abc 4 def 4 ghi 4 jkl 4 mno Required output: Id Name 4 abc,def,ghi,jkl,mno Query: SELECT ID, ...READ MORE

Feb 23 in Database by Neha
• 8,560 points
120 views
0 votes
0 answers

SQL: Display Full Name + Filter By Subject

Feb 22 in Database by Neha
• 8,560 points
20 views
0 votes
0 answers

What is "with (nolock)" in SQL Server?

Can someone explain the ramifications of using ...READ MORE

Feb 22 in Database by Vaani
• 7,020 points
96 views
0 votes
0 answers

What is the definition of cardinality in SQL?

My book definition of Database Systems does ...READ MORE

Feb 18 in Database by Neha
• 8,560 points
124 views
0 votes
0 answers

Selecting COUNT(*) with DISTINCT

In SQL Server 2005, I have a ...READ MORE

Feb 14 in Database by Neha
• 8,560 points
79 views
0 votes
0 answers

How do I UPDATE from a SELECT in SQL Server?

INSERT INTO Table (col1, col2, col3) SELECT col1, ...READ MORE

Feb 4 in Database by Vaani
• 7,020 points
20 views
0 votes
0 answers

how to create a SQL table?

Feb 1 in Database by Neha
• 8,560 points
22 views
0 votes
0 answers

what does sql stand for?

Feb 1 in Database by Neha
• 8,560 points
12 views
0 votes
0 answers

How to add constraints in SQL?

Jan 31 in Database by Neha
• 8,560 points
12 views
0 votes
0 answers

how to use sql server management studio

Jan 31 in Database by Neha
• 8,560 points
18 views
0 votes
0 answers

How to Secure Postgres in cilium like Cassanda.

I want help in writing  code in ...READ MORE

Oct 14, 2020 in Database by Aryan
• 190 points
249 views
0 votes
0 answers

'NoneType' object has no attribute 'name'

in the models.py: name = models.CharField(max_length=50, db_index=True) gender = ...READ MORE

Jun 18, 2020 in Database by prince
• 120 points

edited Jun 18, 2020 by Gitika 2,165 views
0 votes
0 answers

Request for SQL Query

Hi team, How can I get a distinct ...READ MORE

Jun 8, 2020 in Database by vnk
• 390 points
215 views