Most viewed questions in Database

0 votes
1 answer

SQL count rows in a table

A fast way of doing this would ...READ MORE

Feb 21, 2022 in Database by Neha
 • 9,060 points • 561 views
0 votes
1 answer

What are the various MySQL Workbench editions?

MySQL Workbench is mainly available in three ...READ MORE

Dec 6, 2018 in Database by CodingByHeart77
 • 3,740 points • 561 views
0 votes
1 answer

Not equal <> != operator on NULL

Standard SQL-92 is represented by >; its ...READ MORE

Sep 18, 2022 in Database by narikkadan
 • 63,420 points • 559 views
0 votes
0 answers

Equivalent of Oracle's RowID in SQL Server

What does SQL Server's RowID resemble in ...READ MORE

Aug 30, 2022 in Database by Kithuzzz
 • 38,010 points • 559 views
0 votes
1 answer

Logging Levels in Cassandra

ALL: All levels including custom levels TRACE: Designates finer-grained informational ...READ MORE

Jun 28, 2018 in Database by shams
 • 3,670 points • 558 views
0 votes
1 answer

How to enter a series of numbers automatically in Excel

Excel, unlike other Microsoft Office programmes, does ...READ MORE

Apr 4, 2022 in Database by Edureka
 • 13,670 points • 557 views
0 votes
0 answers

How to generate a Guid in SQL Server?

I have to make a SQL Id ...READ MORE

Sep 5, 2022 in Database by Kithuzzz
 • 38,010 points • 556 views
0 votes
1 answer

Cassandra Data Model

Cassandra Data Model consists of four main ...READ MORE

Aug 21, 2018 in Database by kurt_cobain
 • 9,390 points • 556 views
0 votes
1 answer

What is REVOKE in MySQL?

This command is used to withdraw user’s ...READ MORE

Nov 23, 2018 in Database by Sahiti
 • 6,370 points • 555 views
0 votes
1 answer

Log into MariaDB Server as root

To log into the server as root, ...READ MORE

Mar 18, 2019 in Database by Gargi
 • 554 views
0 votes
0 answers

SQL Server® 2016, 2017 and 2019 Express full download

Previous versions of SQL Server Express were ...READ MORE

Sep 6, 2022 in Database by Kithuzzz
 • 38,010 points • 553 views
0 votes
1 answer

Using ORDER BY and GROUP BY together

Correctly use the  group by: select l.* from table ...READ MORE

Sep 20, 2022 in Database by narikkadan
 • 63,420 points • 552 views
0 votes
0 answers

Real life example, when to use OUTER / CROSS APPLY in SQL

With a colleague, I've been researching CROSS/OUTER ...READ MORE

Aug 25, 2022 in Database by Kithuzzz
 • 38,010 points • 552 views
0 votes
0 answers

How to get current datetime in SQL?

In order to add the current date ...READ MORE

Aug 30, 2022 in Database by Kithuzzz
 • 38,010 points • 549 views
0 votes
0 answers

No backupset selected to be restored SQL Server 2012

I have a filestream-enabled SQL Server 2012 ...READ MORE

Aug 28, 2022 in Database by Kithuzzz
 • 38,010 points • 547 views
0 votes
1 answer

how do I calculate discount with if function in excel

Notes about the release; Frameworks to aim ...READ MORE

Mar 25, 2022 in Database by gaurav
 • 23,260 points • 547 views
0 votes
1 answer

Access HFile without using Hbase

Yes, it's very much possible to access ...READ MORE

Aug 9, 2018 in Database by kurt_cobain
 • 9,390 points • 544 views
0 votes
0 answers

Trouble Connecting to sql server Login failed. "The login is from an untrusted domain and cannot be used with Windows authentication"

I want to host a SQL server ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
 • 38,010 points • 540 views
0 votes
1 answer

Software requirements to install DB2 on Linux

Before installing the DB2 server, your system ...READ MORE

Mar 20, 2019 in Database by Yamini
 • 540 views
0 votes
1 answer

Number of elements in a single dimension variant array in excel

You must do UBound - LBound + ...READ MORE

Mar 24, 2022 in Database by gaurav
 • 23,260 points • 539 views
0 votes
1 answer

What are the advanced MySQL Wokrbench capabilities?

Advanced MySQL Capabilities Provides an extension system that ...READ MORE

Dec 10, 2018 in Database by Sahiti
 • 6,370 points • 539 views
0 votes
1 answer

How to rename a column in a database table using SQL?

For SQL Server, use sp_rename USE AdventureWorks; GO EXEC sp_rename 'Customers.CustomerTerritory.TerritoryID', ...READ MORE

Feb 9, 2022 in Database by Neha
 • 9,060 points • 538 views
0 votes
1 answer

Why is SELECT * considered harmful?

If you add fields to the table, ...READ MORE

Sep 27, 2019 in Database by Omaiz
 • 560 points • 537 views
0 votes
0 answers

No process is on the other end of the pipe (SQL Server 2012)

I've got this error: A connection was successfully ...READ MORE

Aug 18, 2022 in Database by Kithuzzz
 • 38,010 points • 535 views
0 votes
1 answer

How to intsall MongoDB in Windows?

Downloading and Installing MongoDB is the easiest ...READ MORE

Mar 1, 2019 in Database by Priyaj
 • 58,090 points • 535 views
0 votes
1 answer

How does database indexing work

If you have a book about dogs ...READ MORE

Oct 4, 2019 in Database by Daric
 • 500 points • 530 views
0 votes
1 answer

Unpivot with column name

Your inquiry is quite near. The following ...READ MORE

Sep 16, 2022 in Database by narikkadan
 • 63,420 points • 529 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,020 points • 529 views
0 votes
0 answers

How can I delete using INNER JOIN with SQL Server?

In SQL Server 2008, I want to ...READ MORE

Aug 23, 2022 in Database by Kithuzzz
 • 38,010 points • 527 views
0 votes
0 answers

How to secure email ?

do you think how to secure email ...READ MORE

Dec 21, 2018 in Database by hill
 • 120 points
edited Jan 7, 2019 by hill • 527 views
0 votes
1 answer

How do I run an sql query in php?

Try this: <?php $conn = new mysqli('localhost', 'jaydeep_mor', 'jaydeep_mor', ...READ MORE

Sep 10, 2022 in Database by narikkadan
 • 63,420 points • 526 views
0 votes
0 answers

How to make a query with group_concat in sql server ?

I am aware that the Group Concat ...READ MORE

Aug 28, 2022 in Database by Kithuzzz
 • 38,010 points • 525 views
0 votes
1 answer

What is the UPDATE command in MySQL?

This statement is used to modify the ...READ MORE

Nov 28, 2018 in Database by Sahiti
 • 6,370 points • 523 views
0 votes
0 answers

What is the purpose of Order By 1 in SQL select statement?

I discovered numerous views with an order ...READ MORE

Aug 19, 2022 in Database by Kithuzzz
 • 38,010 points • 521 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 • 521 views
0 votes
1 answer

What is the ALTER command in MySQL?

ALTER The ALTER command is used to add, ...READ MORE

Nov 28, 2018 in Database by Sahiti
 • 6,370 points • 519 views
0 votes
1 answer

How to extract only the year from the date in sql server 2008?

To obtain the year from the given ...READ MORE

Sep 15, 2022 in Database by narikkadan
 • 63,420 points • 518 views
0 votes
1 answer

Restrictions while installing DB2 Server on Linux using DB2 Setup Wizard

Hey it would be helpful if you ...READ MORE

Mar 20, 2019 in Database by Yesha
 • 518 views
0 votes
1 answer

What is an ALIAS command?

The ALIAS name can be given to ...READ MORE

Oct 22, 2018 in Database by DataKing99
 • 8,240 points • 513 views
0 votes
1 answer

How do I enable Oracle automatically on systemboot?

To enable the database service to start ...READ MORE

Oct 5, 2018 in Database by Frankie
 • 9,830 points • 512 views
0 votes
1 answer

SQL Server CASE .. WHEN .. IN statement

Two forms of CASE statements are getting ...READ MORE

Feb 8, 2022 in Database by Vaani
 • 7,020 points • 511 views
0 votes
1 answer

what is the syntax of OR statement in MySQL?

The OR operator displays those records which ...READ MORE

Dec 1, 2018 in Database by Sahiti
 • 6,370 points • 511 views
0 votes
0 answers

SQLException: No suitable Driver Found for jdbc:oracle:thin:@//localhost:1521/orcl

I'm attempting to create a Java EE ...READ MORE

Aug 15, 2022 in Database by Kithuzzz
 • 38,010 points • 510 views
0 votes
1 answer

What is GROUP BY statement in MySQL?

This statement is used with the aggregate ...READ MORE

Nov 23, 2018 in Database by Sahiti
 • 6,370 points • 510 views
0 votes
1 answer

Install SQQL Server agent on Linux

Hey Rajni, Execute the following commands: sudo apt-get ...READ MORE

Mar 17, 2019 in Database by Rakesh
 • 509 views
0 votes
0 answers

The node to traverse cannot be null (Hibernate SQL)

I'm using hibernate to run the following ...READ MORE

Aug 23, 2022 in Database by Kithuzzz
 • 38,010 points • 508 views
0 votes
1 answer

How to sort by dates excel?

You can sort dates in a worksheet ...READ MORE

Mar 31, 2022 in Database by gaurav
 • 23,260 points • 508 views
0 votes
0 answers

How to DROP multiple columns with a single ALTER TABLE statement in SQL Server?

In one ALTER TABLE statement, I would ...READ MORE

Sep 2, 2022 in Database by Kithuzzz
 • 38,010 points • 507 views
0 votes
1 answer

Excel - Split cell with a delimiter and if delimiter not found get complete cell value to another cell

Select the row or column that you ...READ MORE

Feb 23, 2022 in Database by gaurav
 • 23,260 points • 507 views
0 votes
0 answers

SQL Differences between stored procedure and triggers

I'm having problems comprehending how a stored ...READ MORE

Aug 28, 2022 in Database by Kithuzzz
 • 38,010 points • 504 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.