/SQL/Sql select only first occurrence

Sql select only first occurrence

How to fetch first 5 characters in sql

Select SUBSTRING(StudentName,1,5) as studentname from student

1

Sql select only first occurrence

SELECT FIRST(column_name) FROM table_name;

0

Similar codes

1 vote344 views1 answer
Check message id sql server
SQL
0 vote365 views1 answer
Returning with sqlalchemy
SQL
3 votes370 views1 answer
Oracle failed login attempts
SQL
0 vote337 views1 answer
Changer un mot de passe mysql
SQL
0 vote353 views1 answer
Oracle sql date winter time
SQL
0 vote353 views1 answer
How to check the port of mysql installation in mac
SQL
1 vote417 views1 answer
Default
SQL
0 vote401 views1 answer
Sql trim whitespace
SQL
0 vote344 views1 answer
Mysql shell set time_zone
SQL
50 votes420 views4 answers
Sql alter type of column
SQL

Share