Most answered questions in Database

0 votes
0 answers

ORA-00904: invalid identifier

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

May 20, 2022 in Database by Kichu
• 19,050 points
896 views
0 votes
0 answers

phpMyAdmin - Error > Incorrect format parameter?

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

May 19, 2022 in Database by Kichu
• 19,050 points
932 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, 2022 in Database by Kichu
• 19,050 points
1,440 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, 2022 in Database by Edureka
• 13,670 points
475 views
0 votes
0 answers

Unprotect workbook without password

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

Apr 7, 2022 in Database by Edureka
• 13,670 points
332 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, 2022 in Database by Edureka
• 13,670 points
706 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, 2022 in Database by Edureka
• 13,670 points
243 views
0 votes
0 answers

Datatables export Excel

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

Apr 7, 2022 in Database by Edureka
• 13,670 points
1,057 views
0 votes
0 answers

Excel formula for reverse percentage calculation

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

Apr 7, 2022 in Database by Edureka
• 13,670 points
817 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, 2022 in Database by Edureka
• 13,670 points
233 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, 2022 in Database by Edureka
• 13,670 points
310 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, 2022 in Database by Edureka
• 13,670 points
252 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, 2022 in Database by Edureka
• 13,670 points
398 views
0 votes
0 answers

Make sentence from data in cells in Excel

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

Apr 6, 2022 in Database by Edureka
• 13,670 points
764 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, 2022 in Database by gaurav
• 23,260 points
401 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, 2022 in Database by gaurav
• 23,260 points
285 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, 2022 in Database by Edureka
• 13,670 points
391 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, 2022 in Database by Edureka
• 13,670 points
477 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, 2022 in Database by Edureka
• 13,670 points
2,136 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, 2022 in Database by Edureka
• 13,670 points
1,959 views
0 votes
0 answers

Laravel - Datatables export excel from filtered data

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

Mar 28, 2022 in Database by Edureka
• 13,670 points
4,413 views
0 votes
0 answers

Count colored cell on excel automatically

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

Mar 28, 2022 in Database by Edureka
• 13,670 points
247 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, 2022 in Database by Edureka
• 13,670 points
1,921 views
0 votes
0 answers

Excel PERCENTRANK.INC in Javascript

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

Mar 23, 2022 in Database by Edureka
• 13,670 points
340 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, 2022 in Database by Edureka
• 13,670 points
1,450 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, 2022 in Database by Vaani
• 7,060 points
563 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, 2022 in Database by Vaani
• 7,060 points
481 views
0 votes
0 answers

Order Of Execution of the SQL query

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

Feb 25, 2022 in Database by Vaani
• 7,060 points
712 views
0 votes
0 answers

SELECT.... WHERE... OR

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

Feb 25, 2022 in Database by Vaani
• 7,060 points
293 views
0 votes
0 answers

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

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

Feb 24, 2022 in Database by Hemant
• 140 points
298 views
0 votes
0 answers

Testing question and answer

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

Feb 24, 2022 in Database by anonymous
• 140 points
248 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, 2022 in Database by Edureka
• 13,670 points
335 views
0 votes
0 answers

If Cell Starts with Text String... Formula

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

Feb 24, 2022 in Database by Edureka
• 13,670 points
1,488 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, 2022 in Database by Edureka
• 13,670 points
558 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, 2022 in Database by Edureka
• 13,670 points
1,807 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, 2022 in Database by Neha
• 9,060 points
5,578 views
0 votes
0 answers

SQL: Display Full Name + Filter By Subject

Feb 22, 2022 in Database by Neha
• 9,060 points
225 views
0 votes
0 answers

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

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

Feb 22, 2022 in Database by Vaani
• 7,060 points
535 views
0 votes
0 answers

What is the definition of cardinality in SQL?

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

Feb 18, 2022 in Database by Neha
• 9,060 points
653 views
0 votes
0 answers

Selecting COUNT(*) with DISTINCT

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

Feb 14, 2022 in Database by Neha
• 9,060 points
353 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, 2022 in Database by Vaani
• 7,060 points
359 views
0 votes
0 answers

how to create a SQL table?

Feb 1, 2022 in Database by Neha
• 9,060 points
263 views
0 votes
0 answers

what does sql stand for?

Feb 1, 2022 in Database by Neha
• 9,060 points
183 views
0 votes
0 answers

How to add constraints in SQL?

Jan 31, 2022 in Database by Neha
• 9,060 points
209 views
0 votes
0 answers

how to use sql server management studio

Jan 31, 2022 in Database by Neha
• 9,060 points
216 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
671 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 3,216 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
562 views
+1 vote
0 answers

What are the advantages of SQL? [closed]

Dec 28, 2019 in Database by Yuth
• 130 points

closed Dec 30, 2019 by Kalgi 870 views