Most viewed questions in Database

0 votes
1 answer

What is schema?

The description of a database is called ...READ MORE

Aug 17, 2018 in Database by CodingByHeart77
 • 3,740 points • 612 views
0 votes
1 answer

What is a Relationship and what are they?

Relation or links are between entities that ...READ MORE

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

What are the hardware requirements to install DB2 on Linux?

Hey @Kiran, DB2 Server is available for ...READ MORE

Mar 20, 2019 in Database by Kevin
 • 610 views
0 votes
1 answer

Can we store images in database

Beware that serving images from DB is ...READ MORE

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

Use of contains() in sql server

The straightforward method is shown here. You ...READ MORE

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

What is a covered Index?

A covering index is an index that contains all ...READ MORE

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

How do I UPDATE from a SELECT in SQL Server?

MERGE INTO YourTable T USING ...READ MORE

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

Explain Data Dictionary

Data dictionary is a set of information ...READ MORE

Aug 30, 2018 in Database by CodingByHeart77
 • 3,740 points • 603 views
0 votes
1 answer

Delete all the records

You can use this if you have ...READ MORE

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

How can prepared statements protect from SQL injection attacks?

In what ways do prepared statements aid ...READ MORE

Aug 11, 2022 in Database by Kithuzzz
 • 38,010 points • 601 views
0 votes
0 answers

Can PHP arrays hold items of different type?

The definition of an array in other ...READ MORE

Nov 16, 2022 in Database by Ashwini
 • 5,430 points • 600 views
0 votes
1 answer

Convert a number to a letter in C# for use in Microsoft Excel [duplicate]

If you are familiar with using formulas ...READ MORE

Feb 23, 2022 in Database by gaurav
 • 23,260 points • 600 views
0 votes
1 answer

Error: Cannot connect to the server using SA account - MSSQL Linux

The option is to reset the system ...READ MORE

Mar 17, 2019 in Database by Fatima
 • 600 views
0 votes
1 answer

How to format datetime in SQL SERVER

In SQL Server 2012 and up you ...READ MORE

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

What is a Foreign key?

Foreign key maintains referential integrity by enforcing ...READ MORE

Oct 26, 2018 in Database by Sahiti
 • 6,370 points • 599 views
0 votes
1 answer

How do i install MongoDB on ubuntu?

Hey @Aryaa, follow these steps: Import Public Key sudo ...READ MORE

Mar 15, 2019 in Database by Avinash
 • 596 views
0 votes
1 answer

Buckets in HIVE

There are two main reasons for performing bucketing ...READ MORE

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

SQL Server: Multiple table joins with a WHERE clause

It matters whether you place the filter ...READ MORE

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

How to delete duplicate rows in SQL Server?

CTEs and ROW_NUMBER can be combined together which will ...READ MORE

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

How does Docker CLI connects with DB?

To connect Docker CLI with a Database, ...READ MORE

Oct 19, 2020 in Database by lyana
 • 595 views
0 votes
0 answers

I need data from the the site of Justdial for my business. Anybody can tell from where do i get that?

Sep 1, 2020 in Database by Satish
 • 120 points • 595 views
0 votes
0 answers

SQL to find the number of distinct values in a column

In a column, I can choose each ...READ MORE

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

Install MS-SQL Server on Windows

Follow these steps  if you wish to ...READ MORE

Mar 18, 2019 in Database by Kiran
 • 592 views
0 votes
0 answers

Display data from SQL database into php/ html table.

I want to display one of my ...READ MORE

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

Install MariaDB on Ubuntu

Hey Ravi, execute the following instructions to ...READ MORE

Mar 18, 2019 in Database by Kiran
 • 591 views
0 votes
0 answers

How to install Oracle DB on ubuntu?

Can anyone help me with the step ...READ MORE

Feb 28, 2019 in Database by Sukanya Rajput
 • 590 views
0 votes
1 answer

Using Real Time flume Data for Analysis

By using MorphlineSolrSink we can extract, transform ...READ MORE

Jul 17, 2018 in Database by kurt_cobain
 • 9,390 points • 589 views
0 votes
1 answer

What is the syntax of USE statement in MySQL?

The USE statement is used to mention ...READ MORE

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

Data model operations in Hbase

1. Get(returns attributes for a specified row, Gets ...READ MORE

Jul 16, 2018 in Database by Data_Nerd
 • 2,390 points • 585 views
0 votes
0 answers

How do I query for all dates greater than a certain date in SQL Server?

I tried this: SELECT * FROM dbo.March2010 A WHERE ...READ MORE

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

What is the difference between HAVING and WHERE in SQL?

HAVING: It is used to check after the aggregation ...READ MORE

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

Excel VBA - exit for loop

When we need to depart the For ...READ MORE

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

Difference between EXISTS and IN in SQL?

Although the exists keyword can be used ...READ MORE

Sep 11, 2022 in Database by narikkadan
 • 63,420 points • 581 views
+1 vote
1 answer

How to migrate a PostgreSQL database into a SQLServer one?

Hello @kartik, The easier way to accomplish this. First ...READ MORE

May 13, 2020 in Database by Niroj
 • 82,880 points • 579 views
0 votes
0 answers

com.microsoft.sqlserver.jdbc.SQLServerDriver not found error

I'm having the same issue as this thread. ...READ MORE

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

Create new role - postgresql on ubuntu

If you are logged in as the postgres account, ...READ MORE

Mar 22, 2019 in Database by Danny
 • 578 views
0 votes
1 answer

What is MariaDB?

MariaDB is a database management system (DBMS), ...READ MORE

Mar 18, 2019 in Database by Janice
 • 572 views
0 votes
0 answers

How to rename a table in SQL Server?

The SQL query that I have used is : ALTER ...READ MORE

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

What are the MySQL Enterprise Backup operations available from MySQL Workbench?

There are mainly two MySQL Enterprise Backup ...READ MORE

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

Get month and year from date cells Excel

The steps to modify the date format ...READ MORE

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

How would I find the second largest salary from a employee table? [closed]

To find the 2nd largest salary from ...READ MORE

Feb 8, 2022 in Database by Vaani
 • 7,020 points • 570 views
0 votes
0 answers

How can I set a custom date time format in Oracle SQL Developer?

Date values are shown in Oracle SQL ...READ MORE

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

Importing Excel files into R, xlsx or xls

To get started, here's a template for ...READ MORE

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

How do I create a table based on another table

Although CREATE TABLE AS... SELECT does exist ...READ MORE

Sep 12, 2022 in Database by narikkadan
 • 63,420 points • 567 views
0 votes
0 answers

What is the difference between drop table and delete table in SQL Server?

What is the distinction between the following ...READ MORE

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

System requirements to install MSSQL Server on Linux

These would be the hardware requirements to ...READ MORE

Mar 17, 2019 in Database by Mohor
 • 565 views
0 votes
1 answer

Excel formula to remove space between words in a cell

There are three fast techniques to get ...READ MORE

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

Why is MongoDB preferred?

MongoDB is considered to be best NoSQL ...READ MORE

Jul 24, 2018 in Database by shams
 • 3,670 points
edited Jun 1, 2023 by Srinath • 563 views
0 votes
1 answer

macro in excel tablet

Add Macros to the Ribbon Tab You'll make ...READ MORE

Apr 4, 2022 in Database by Edureka
 • 13,670 points • 561 views
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
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.