Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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.

asked 14 Oct '22, 06:45

sorhelene2's gravatar image

accept rate: 0%

edited 14 Oct '22, 07:12

Graeme%20Perrow's gravatar image

Graeme Perrow

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.


permanent link

answered 14 Oct '22, 07:09

Mark%20Culp's gravatar image

Mark Culp
accept rate: 41%

edited 14 Oct '22, 07:10

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

(14 Oct '22, 07:25) sorhelene2
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 14 Oct '22, 06:45

question was seen: 361 times

last updated: 14 Oct '22, 07:25