Q&A Discussions

how to find a value in a database that contains many tables without knowing its column name?

16th Jun 2019, 1:14 PM

Ebugo_

cell column_name mysql query sql sql_server tables value-types

1 Vote

how Union keyword decide to remove duplicate value if there are multi column result set.

30th Sep 2018, 7:16 PM

Amir Rafati

sql union

0 Votes

Given a csv file and a column name, print the elements in the given column.

13th Jul 2016, 2:32 AM

Sanjay Yadav

#sololearn

-4 Votes

Can I use the column number in the select clause on the place the name?

18th Apr 2022, 6:51 PM

Shubham Mandgaonkar

0 Votes

How to Allow Only Alphabets in Column – Create Check Constraint to Insert Only Alphabets

7th Apr 2016, 2:57 AM

Diego Veronez Nunes

0 Votes

Is there a way to specify where the new column will be placed or ordered?

28th Mar 2017, 10:02 AM

Akwin Lopez

0 Votes

How do I get this code to print a list of numbers instead of a column of numbers?

27th Jun 2016, 9:31 PM

Ian Staley

lists python3

1 Vote

How can I easily achieve this landing one column page display using html and css only?

20th Aug 2019, 11:04 PM

Evan

html_and_css_only landing_page

0 Votes

6th Sep 2021, 7:17 AM

DN Josh

Inseting data

column insert sql

0 Votes

i have three column in my transaction table id int, amount int, balance int. I want to write a query when I insert new row balnce column automatically filled by previous row value +(-) this row value.

1st Nov 2018, 10:50 AM

Trevor P Sunny

mysql sql

0 Votes

# Sort along rows in descending order. temp =np.array([[11,22,33,44,55], [55,66,77,88,11],[88,99,10,11,22],[11,22,33,55,44],[11

27th Oct 2016, 1:21 PM

santosh ojha

column descending python sort

2 Votes

Why does setting the table width to 100% make the the first column wider than the second one?

3rd Oct 2021, 12:52 PM

Zhenis Otarbay

column-width tables width

1 Vote

Hi Friend i have some doubt .. suppose i want to display a column in center with justified then how to do it??

17th Nov 2020, 9:38 AM

Mohammed Elsir

3 Votes

What is use of clearfix and column and how do we know where to insert them in html/css?

7th Aug 2018, 3:20 AM

g3112

css css3 html html5 web webdevelopment

0 Votes

how do we sort by using the last three letters of names of people in the people column in a table?

29th May 2021, 4:22 AM

Knowledge Pedia

How I can parse to float the string data of a specific column in a dataframe?

2 Votes

5 Answers

15th Jul 2016, 12:46 AM

Harsha Vardhan

columns dataframe float pandas parse python

0 Votes

The "17 Code Project" question left me confused about columns named with clause key words--Please help!

3rd Nov 2020, 12:06 AM

Rosana Rodríguez Milanés

17 as clause column name used word

3 Votes

9 Answers

3rd Feb 2022, 10:42 PM

Ana Collado

how to generate 3 digit unique id number in php and store database in ID column

mysql php sql

0 Votes

Hi guys, Anyone knows how can I add a column after join table or execute in first table in SQL?

22nd Jul 2019, 11:11 AM

Love Barot

mysql sql

1 Vote

anyone has a 6 numbers column lottery program with choice of random fill or user input?

12th Jul 2017, 11:11 PM

Reza Reisi Vanani

homework project sos

0 Votes

What is the general format of a loop to process the elements in column j of a two dimensional array in cpp?

13th Sep 2016, 7:21 PM

Nitzan Levi

arrays cpp loops

0 Votes

5 Answers

18th Feb 2020, 5:42 PM

Aadil Ali

in case the input was null for a column NOT NULL..an error will appear or what ?

1 Vote

is that possible to select twice a column from a table and modify only one of them?

17th Jun 2017, 12:29 AM

De Vinci

0 Votes

Does anyone have a link to a recent challenge post about converting column numbers to Excel format?

15th Dec 2016, 12:20 AM

Rane Foong

challenge excel

0 Votes

I wAnt to create a dynamic table according to data And last column two radio button with same name .

24th Feb 2020, 4:46 AM

Yeldan Dulan

gordon html javascript loop tabletemplate

1 Vote

How can i create a database with a table wich has 'id' column and 'id' will be auto increment.

10th Jun 2020, 9:15 AM

Prince Chaurasia

mysql php

1 Vote

which keyword is used for showing column info instead of SHOW keyword? Such as "SHOW COLUMNS from Student"

23rd Dec 2016, 10:35 AM

Twaha Rahman

column info mssql query

0 Votes

How to extract the element of 2nd column of 5th row from a CSV file in python or Linux? I need both.

20th Aug 2018, 5:43 PM

Nasir Ahmed

python

1 Vote

if after AS we put a column name which is already present then will it replace the old column?

15th Sep 2021, 4:58 AM

Sourya Banerjee

0 Votes

Can the DROP statement be used to delete rows too by replacing drop column with drop ROW?

3rd Jul 2016, 5:47 AM

Anindo Bhattacharya

0 Votes

Guys what is the ans for this question

27th Aug 2016, 4:27 AM

Nakul Dumblekar

column date html5 range reset

3 Votes

5 Answers

17th Mar 2017, 1:26 PM

Lil Wayne

If two-dimentional array contains 2indices -row and column then what are the three indices in three-dimentional array in php?

arrays

0 Votes

Why is my navigation menu hiding under the header bar? I want it to come just after the header in a 1 column display.

8th Sep 2018, 5:51 AM

Mabruka Mannan

css3 footer header html5 nav

0 Votes

6 Answers

9th Jun 2021, 8:03 PM

DN Josh

Can we use min or max function with count function? In a single query on a column of a table

0 Votes

Can space be given while writing the column name like for example : First Name instead of FirstName

21st Jul 2016, 6:29 PM

ascetic

0 Votes

Anyone knows how can we do to have a new column sum which increase incremental on each row?

29th Jul 2017, 5:13 AM

Srinivas Nahak

functions sql

0 Votes

How to combine two columns in pandas?

30th Jul 2016, 8:18 PM

Ghinea Bogdan

column combine pandas python3

0 Votes

Is anyone here familiar with Oracle PL/SQL?Is it possible to print result set from cursor without using column names?If so how?

27th Oct 2022, 7:50 AM

Nabanita Borkakoti

cursors database oracle pl/sql

2 Votes

Could we set the "Telephone" column as the primary key of this table, as long as it has unique values?

8th Mar 2017, 12:26 PM

Maha Devan

primarykey sql

0 Votes

need last 5 weeks of data , I have week day table column weekcod and having data 202001,202002,202003......202052,202053

24th Jan 2017, 3:36 PM

Muhammad Eloqda

5 dat needlast of weeks

-3 Votes

Kindly explain nested for loop to create row and columns(row is 3 and column is 5). In C++.

14th Jan 2021, 5:01 PM

Steve Km

for loops

0 Votes

I have a question in PHP. In two-dimension array, how to declare an array by assigning both numeric in row and column anddisplay

20th Feb 2017, 10:09 PM

Mufakkir

array multi-dimension numeric php

1 Vote

how can I break a line as line 1 & line 2 of address column while inserting values in table ?

12th May 2019, 3:24 PM

Avijit Bakshi

insert sql tables

-1 Vote

When you use concat and make new column out of it, does it automatically add to the database as a new column?

8th Jul 2016, 2:58 PM

Mohan pochampalle

1 Vote

Please see this code and tell me why is there no line between 2nd and third column and how do i add it

13th Jul 2017, 6:26 AM

Ej Calsado

code help html

2 Votes

I have 2 mysql tables i.e customers1 and customers2 with same column names. How do I search from all but only show results of 1?

21st May 2017, 1:17 PM

A.Shipra

<?php

0 Votes

Here we use minimum as a column for the result know whether it displays only in the output or it stores (add) in the employee

18th Jul 2019, 7:28 AM

joseph sakala

mysql sql

0 Votes

Write a method to find the sum of all the elements of a particular column in the integer matrix

19th Dec 2019, 5:45 PM

Lakshmi Reddy Sanikommu

java

0 Votes

if you alter a table to add a column and make it unable to accept null, what happens to the existing rows?

17th Nov 2016, 12:42 PM

沫雅公子

1 Vote