Database - Introduction to SQL - Discussion
Discussion Forum : Introduction to SQL - True or False (Q.No. 30)
30.
The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."
Discussion:
7 comments Page 1 of 1.
Zaynab AlaaEldien said:
2 years ago
The wildcard asterisk (*) in SQL is generally used to represent all columns, not a sequence of characters.
Jojo said:
9 years ago
Right @Bhushan.
Pooja Mhatre said:
9 years ago
According to me, it is correct answer because * is not wildcard symbol.
Bhushan said:
10 years ago
Its about MS-Access. Not SQL-92.
Jay Patel said:
10 years ago
For Sequence of character SQL use (%) wildcards not (*).(*) is used with SELECT for all Columns. Here in question they are talking about value of columns have sequence of character. Ex- you want name starting with 'J' and remaining name character will be 0 or any sequence of Character so,
Query like - SELECT Name from <Table-Name> where Name like 'J%';
You will get Name like - Jay, J, Jai any thing like.
Query like - SELECT Name from <Table-Name> where Name like 'J%';
You will get Name like - Jay, J, Jai any thing like.
Meghanak.v. said:
1 decade ago
You got confused i think. sql 92 wildcards are % and _ only. it's specified in 18th question of general questions section.Regarding *, in sql 92 it's used to select all columns. It's not a wild card in sql 92
Kamal malhotra said:
1 decade ago
Hi, i think its true as * means anything or in any sequence.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers