cancel
Showing results for 
Search instead for 
Did you mean: 

How to fetch specific record in SQL database?

10-14-2022 8:45 AM
1215 views 2 comments
0 Likes
SAP Managed Tags
Subscribe

Hello there, I have a database related to different fonts. There are millions of records in the database. Now I want to fetch the specific record from the specific table in the database. Can anyone tell me how it possible. Thanks in advance.

0 Likes

Accepted Solutions (0)

Answers (1)

Answers (1)

MarkCulp
Participant

You will need to use a WHERE on your SELECT statement. The condition used in the WHERE clause will be dependent on your database schema. If your table has a primary key then the form will be

SELECT column FROM table WHERE pk = val

There are many online SQL tutorials. You may benefit from googling "SQL tutorial" and going through the resources.

HTH

0 Likes

Thank you so much for helping me. I will follow the following instructions to solve my problem.